APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PER_ALL_POSITIONS

Line 1383: FROM per_all_positions pap

1379: -------------
1380: /* Cursor to retrieve Position of Employee */
1381: CURSOR csr_position(p_position_id NUMBER) IS
1382: SELECT pap.name
1383: FROM per_all_positions pap
1384: WHERE pap.position_id = p_position_id;
1385: -------------
1386: CURSOR csr_job (p_job_id NUMBER)IS
1387: SELECT name

Line 1465: l_position per_all_positions.name%TYPE;

1461: rec_primary_address csr_primary_address%ROWTYPE;
1462: rec_employer_address csr_employer_address%ROWTYPE;
1463: rec_org_address csr_organization_address%ROWTYPE;
1464: l_nationality per_all_people_f.nationality%TYPE;
1465: l_position per_all_positions.name%TYPE;
1466: l_hire_date per_periods_of_service.date_start%TYPE;
1467: l_grade per_grades.name%TYPE;
1468: l_currency hr_organization_information.org_information10%TYPE;
1469: l_organization hr_organization_units.name%TYPE;