@Sumanth V -Oracle - Thanks for your response. I'm a consultant, not an Oracle user but the expectation is to get the information from Fusion Application.

Hello both, Thank you for responses and suggestions. I'm trying to get something that can help with mapping of element_type_id from pay_element_type_vl into different buckets such as Gross pay, Basic pay, deduction, Pensionable, Taxable, NIable, etc.