APPS.PAY_SA_ARCHIVE dependencies on PER_ALL_POSITIONS

Line 946: FROM per_all_positions pap

942:
943: /* Cursor to retrieve Position of Employee */
944: CURSOR csr_position(p_position_id NUMBER) IS
945: SELECT pap.name
946: FROM per_all_positions pap
947: WHERE pap.position_id = p_position_id;
948:
949: /* Cursor to retrieve Cost Center */
950: CURSOR csr_cost_center(p_assignment_id NUMBER) IS

Line 988: l_position per_all_positions.name%TYPE;

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;
992: l_pay_location hr_locations_all.address_line_1%TYPE;