APPS.PAY_SA_ARCHIVE dependencies on PER_GRADES

Line 940: FROM per_grades pg

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

Line 989: l_grade per_grades.name%TYPE;

985: rec_employer_address csr_employer_address%ROWTYPE;
986: rec_org_address csr_organization_address%ROWTYPE;
987: l_nationality per_all_people_f.nationality%TYPE;
988: l_position per_all_positions.name%TYPE;
989: l_grade per_grades.name%TYPE;
990: l_currency hr_organization_information.org_information10%TYPE;
991: l_organization hr_organization_units.name%TYPE;
992: l_pay_location hr_locations_all.address_line_1%TYPE;
993: l_city VARCHAR2(80);