APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PER_GRADES

Line 810: FROM per_grades pg

806: AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER';
807: /* Cursor to retrieve Grade of Employee */
808: CURSOR csr_grade(p_grade_id NUMBER) IS
809: SELECT pg.name
810: FROM per_grades pg
811: WHERE pg.grade_id = p_grade_id;
812: /* Cursor to retrieve Position of Employee */
813: CURSOR csr_position(p_position_id NUMBER) IS
814: SELECT pap.name

Line 856: l_grade per_grades.name%TYPE;

852: rec_org_address csr_organization_address%ROWTYPE;
853: l_nationality per_all_people_f.nationality%TYPE;
854: l_position per_all_positions.name%TYPE;
855: l_hire_date per_periods_of_service.date_start%TYPE;
856: l_grade per_grades.name%TYPE;
857: l_currency hr_organization_information.org_information10%TYPE;
858: l_organization hr_organization_units.name%TYPE;
859: l_pay_location hr_locations_all.address_line_1%TYPE;
860: l_postal_code VARCHAR2(80);