Get Started with Redwood for Oracle Cloud HCM Begin Now
Query To Link PAY_COSTS And GL and xla tables
Summary:
The SQL query I wrote is returning duplicate values.so To remove the duplicate I tried to find the link between payroll and GL tables I did not find any solutions.
Please find the below query.
SELECT
papf.person_number employee_number,
ppnf.display_name emp_name,
paam.ASSIGNMENT_STATUS_TYPE,
pdps.name department,
NVL(xlal.accounted_dr,0) accounted_dr,
NVL(xlal.accounted_cr,0) accounted_cr,
gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,2,gcc.segment2) Project,
gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,3,gcc.segment3) account_dec,
gls.name ledger_name,
0