DBA Data[Home] [Help]

APPS.PAY_US_TAX_WF dependencies on PAY_PAYROLLS_F

Line 312: ,pay_payrolls_f prl

308: CURSOR c_payroll_contact IS
309: select /*+ ordered */ prl.prl_information1 --Bug 3361934
310: from pay_stat_trans_audit pta
311: ,per_assignments_f paf
312: ,pay_payrolls_f prl
313: where prl.payroll_id = paf.payroll_id
314: and prl.prl_information_category = 'US'
315: and paf.assignment_id = pta.assignment_id
316: and pta.transaction_parent_id = ln_transaction_id

Line 458: ,pay_payrolls_f prl

454: select /*+ ordered */ usr.employee_id --Bug 3361934
455: ,pta.assignment_id
456: from pay_stat_trans_audit pta
457: ,per_assignments_f paf
458: ,pay_payrolls_f prl
459: ,fnd_user usr
460: where prl.payroll_id = paf.payroll_id
461: and usr.user_name = prl.prl_information1
462: and prl.prl_information_category = 'US'