DBA Data[Home] [Help]

APPS.PAY_US_W4_WF dependencies on FND_USER

Line 571: ,fnd_user usr

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'
575: and paf.assignment_id = pta.assignment_id

Line 591: ,fnd_user usr

587: select usr.employee_id
588: ,pta.assignment_id
589: from hr_organization_information org
590: ,pay_stat_trans_audit pta
591: ,fnd_user usr
592: where usr.user_name = org.org_information1
593: and pta.assignment_id = ln_current_assignment_id
594: and pta.source4 = ln_transaction_id
595: and pta.source4_type = 'TRANSACTION_ID'