DBA Data[Home] [Help]

APPS.PAY_US_W2_WF dependencies on FND_USER

Line 98: fnd_user usr

94: select usr.employee_id,
95: paf.assignment_id
96: from pay_payrolls_f prl,
97: per_assignments_f paf,
98: fnd_user usr
99: where prl.payroll_id = paf.payroll_id
100: and usr.user_name = prl.prl_information1
101: and prl.prl_information_category = 'US'
102: and paf.assignment_id = ln_current_assignment_id

Line 112: fnd_user usr

108: select usr.employee_id,
109: paf.assignment_id
110: from hr_organization_information org,
111: per_assignments_f paf,
112: fnd_user usr
113: where org.organization_id = (select hsc.segment1
114: from hr_soft_coding_keyflex hsc
115: where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id)
116: and usr.user_name = org.org_information1