APPS.PAY_SA_ARCHIVE dependencies on PER_GRADES

Line 941: FROM per_grades pg

937:
938: /* Cursor to retrieve Grade of Employee */
939: CURSOR csr_grade(p_grade_id NUMBER) IS
940: SELECT pg.name
941: FROM per_grades pg
942: WHERE pg.grade_id = p_grade_id;
943:
944: /* Modified for bug 10255223 */
945: /* Cursor to retrieve Position of Employee */

Line 1002: l_grade per_grades.name%TYPE;

998: rec_org_address csr_organization_address%ROWTYPE;
999: l_nationality per_all_people_f.nationality%TYPE;
1000: /*l_position per_all_positions.name%TYPE; */
1001: l_position hr_all_positions_f.name%TYPE; -- modified for bug 10255223
1002: l_grade per_grades.name%TYPE;
1003: l_currency hr_organization_information.org_information10%TYPE;
1004: l_organization hr_organization_units.name%TYPE;
1005: l_pay_location hr_locations_all.address_line_1%TYPE;
1006: l_city VARCHAR2(80);