Welcome to Oracle Self Learning!

Oracle Payroll - GL  Interface query.

SELECT gl.*
  FROM pay_payroll_actions ppa,
       pay_assignment_actions paa,
       pay_costs pcv,
       gl_interface gl
 WHERE     ppa.payroll_action_id = 201496               -- for costing process
       AND ppa.action_type = 'C'
       AND pcv.transfer_to_gl_flag = 'Y'
       AND ppa.payroll_action_id = paa.payroll_action_id
       AND paa.assignment_action_id = pcv.assignment_action_id
       AND gl.user_je_source_name = 'Payroll'
       AND pcv.ASSIGNMENT_ACTION_ID = 1275993 -- for costing process
       AND gl.reference22 = TO_CHAR (pcv.cost_allocation_keyflex_id)

Team Work More "We" Less "Me"