APPS.PAY_AE_ARCHIVE dependencies on PER_GRADES

Line 958: FROM per_grades_tl pg

954:
955: /* Cursor to retrieve Grade of Employee */
956: CURSOR csr_grade(p_grade_id NUMBER) IS
957: SELECT pg.name
958: FROM per_grades_tl pg
959: WHERE pg.grade_id = p_grade_id;
960:
961: /* Cursor to retrieve Position of Employee */
962: CURSOR csr_position(p_position_id NUMBER) IS

Line 993: l_grade per_grades.name%TYPE;

989: rec_employer_address csr_employer_address%ROWTYPE;
990: rec_org_address csr_organization_address%ROWTYPE;
991: l_nationality VARCHAR2(80); --per_all_people_f.nationality%TYPE;
992: l_position per_all_positions.name%TYPE;
993: l_grade per_grades.name%TYPE;
994: l_job per_jobs.name%TYPE;
995: l_currency hr_organization_information.org_information10%TYPE;
996: l_organization hr_organization_units.name%TYPE;
997: l_pay_location hr_locations_all.address_line_1%TYPE;