APPS.PAY_KW_ARCHIVE dependencies on PER_ALL_POSITIONS

Line 961: FROM per_all_positions pap

957:
958: /* Cursor to retrieve Position of Employee */
959: CURSOR csr_position(p_position_id NUMBER) IS
960: SELECT pap.name
961: FROM per_all_positions pap
962: WHERE pap.position_id = p_position_id;
963:
964: /* Cursor to pick up Payroll Location */
965: CURSOR csr_pay_location(p_location_id NUMBER) IS

Line 981: l_position per_all_positions.name%TYPE;

977: rec_primary_address csr_primary_address%ROWTYPE;
978: rec_employer_address csr_employer_address%ROWTYPE;
979: rec_org_address csr_organization_address%ROWTYPE;
980: l_nationality per_all_people_f.nationality%TYPE;
981: l_position per_all_positions.name%TYPE;
982: l_grade per_grades.name%TYPE;
983: l_job per_jobs.name%TYPE;
984: l_currency hr_organization_information.org_information10%TYPE;
985: l_organization hr_organization_units.name%TYPE;