Query To Link PAY_COSTS And GL and xla tables — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!