DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on PER_ALL_PEOPLE_F

Line 242: FROM per_all_people_f PE,

238: CURSOR psd_xml_employee
239: IS
240: SELECT DISTINCT
241: 'TRANSFER_ACT_ID=P', AA.assignment_action_id
242: FROM per_all_people_f PE,
243: per_all_assignments_f SS,
244: pay_assignment_actions AA,
245: pay_payroll_actions PA ,
246: pay_us_asg_reporting puar

Line 297: per_all_people_f pap,

293: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'),
294: 'TRANSFER_EE_JD_CODE=P', puar.jurisdiction_code
295: FROM pay_us_asg_reporting puar,
296: pay_assignment_actions paa,
297: per_all_people_f pap,
298: per_all_assignments_f paf,
299: pay_payroll_actions ppa
300: WHERE puar.assignment_id=paf.assignment_id
301: AND paf.person_id=pap.person_id