DBA Data[Home] [Help]

APPS.PAY_US_W4_WF dependencies on PAY_PAYROLLS_F

Line 393: ,pay_payrolls_f prl

389: CURSOR c_payroll_contact IS
390: select /*+ ordered */ prl.prl_information1 --Bug 3362223
391: from pay_stat_trans_audit pta
392: ,per_assignments_f paf
393: ,pay_payrolls_f prl
394: where prl.payroll_id = paf.payroll_id
395: and prl.prl_information_category = 'US'
396: and paf.assignment_id = pta.assignment_id
397: and pta.source4 = ln_transaction_id

Line 570: ,pay_payrolls_f prl

566: select /*+ ordered */ usr.employee_id --Bug 3362223
567: ,pta.assignment_id
568: from pay_stat_trans_audit pta
569: ,per_assignments_f paf
570: ,pay_payrolls_f prl
571: ,fnd_user usr
572: where prl.payroll_id = paf.payroll_id
573: and usr.user_name = prl.prl_information1
574: and prl.prl_information_category = 'US'