DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on PER_ALL_PEOPLE_F

Line 2918: ,per_all_people_f PEOPLE

2914: PEOPLE.employee_number,
2915: PEOPLE.suffix,
2916: replace(PEOPLE.national_identifier,' ')
2917: from per_all_assignments_f ASSIGN
2918: ,per_all_people_f PEOPLE
2919: where ASSIGN.assignment_id =l_asgid
2920: and PEOPLE.person_id = ASSIGN.person_id
2921: and l_date_earned BETWEEN ASSIGN.effective_start_date
2922: AND ASSIGN.effective_end_date