APPS.PAY_AE_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 848: per_all_people_f ppf,

844: paf.grade_id grade_id,
845: ppg.group_name group_name,
846: paf.business_group_id bus_grp_id
847: FROM per_assignments_f paf,
848: per_all_people_f ppf,
849: per_periods_of_service pps,
850: pay_people_groups ppg
851: WHERE paf.person_id = ppf.person_id
852: AND paf.assignment_id = p_assignment_id

Line 991: l_nationality VARCHAR2(80); --per_all_people_f.nationality%TYPE;

987: rec_person_details csr_person_details%ROWTYPE;
988: rec_primary_address csr_primary_address%ROWTYPE;
989: rec_employer_address csr_employer_address%ROWTYPE;
990: rec_org_address csr_organization_address%ROWTYPE;
991: l_nationality VARCHAR2(80); --per_all_people_f.nationality%TYPE;
992: l_position per_all_positions.name%TYPE;
993: l_grade per_grades.name%TYPE;
994: l_job per_jobs.name%TYPE;
995: l_currency hr_organization_information.org_information10%TYPE;