DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 833: per_all_people_f ppf,

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

Line 999: l_nationality per_all_people_f.nationality%TYPE;

995: rec_person_details csr_person_details%ROWTYPE;
996: rec_primary_address csr_primary_address%ROWTYPE;
997: rec_employer_address csr_employer_address%ROWTYPE;
998: rec_org_address csr_organization_address%ROWTYPE;
999: l_nationality per_all_people_f.nationality%TYPE;
1000: /*l_position per_all_positions.name%TYPE; */
1001: l_position hr_all_positions_f.name%TYPE; -- modified for bug 10255223
1002: l_grade per_grades.name%TYPE;
1003: l_currency hr_organization_information.org_information10%TYPE;