APPS.PAY_SA_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 832: per_all_people_f ppf,

828: paf.position_id pos_id,
829: paf.grade_id grade_id,
830: paf.business_group_id bus_grp_id
831: FROM per_assignments_f paf,
832: per_all_people_f ppf,
833: per_periods_of_service pps
834: WHERE paf.person_id = ppf.person_id
835: AND paf.assignment_id = p_assignment_id
836: AND pps.person_id = ppf.person_id

Line 987: l_nationality per_all_people_f.nationality%TYPE;

983: rec_person_details csr_person_details%ROWTYPE;
984: rec_primary_address csr_primary_address%ROWTYPE;
985: rec_employer_address csr_employer_address%ROWTYPE;
986: rec_org_address csr_organization_address%ROWTYPE;
987: l_nationality per_all_people_f.nationality%TYPE;
988: l_position per_all_positions.name%TYPE;
989: l_grade per_grades.name%TYPE;
990: l_currency hr_organization_information.org_information10%TYPE;
991: l_organization hr_organization_units.name%TYPE;