APPS.PAY_FI_ARCHIVE_PYSA dependencies on PER_ALL_POSITIONS

Line 776: FROM per_all_positions pap

772: WHERE pg.grade_id = p_grade_id;
773: /* Cursor to retrieve Position of Employee */
774: CURSOR csr_position(p_position_id NUMBER) IS
775: SELECT pap.name
776: FROM per_all_positions pap
777: WHERE pap.position_id = p_position_id;
778: CURSOR csr_job (p_job_id NUMBER)IS
779: SELECT name
780: FROM per_jobs

Line 815: l_position per_all_positions.name%TYPE;

811: rec_primary_address csr_primary_address%ROWTYPE;
812: rec_employer_address csr_employer_address%ROWTYPE;
813: rec_org_address csr_organization_address%ROWTYPE;
814: l_nationality per_all_people_f.nationality%TYPE;
815: l_position per_all_positions.name%TYPE;
816: l_hire_date per_periods_of_service.date_start%TYPE;
817: l_grade per_grades.name%TYPE;
818: l_currency hr_organization_information.org_information10%TYPE;
819: l_organization hr_organization_units.name%TYPE;