Oracle SQL Query to Get the costing details of each payroll element assigned to an employee

Hi,

I want to get an sql query that will show me the employee details and the the GL full code assigned to a payroll element that is assigned to a given employee.

The details I am looking for is like what you have in the Oracle application R12 HRMS form. Enter and Maintain>Assignment>Others>Cost Allocation. That will show you the payroll element assigned to each element and their full GL codes.

I have this code which i have written which is working fine, the only issue is that I cannot find a way to link it with the pay_costs table and pay_cost_allocation_keyflex table. The concatenated_segment field in the pay_cost_allocation_keyflex table is what i need. Below is my query