APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on PER_KR_GRADES

Line 446: ,per_kr_grades pkg

442: ,pkg.grade_name second_grade
443: ,pgp.grade_point_name grade_point
444: FROM hr_soft_coding_keyflex hsck
445: ,per_assignments_f paa
446: ,per_kr_grades pkg
447: ,per_kr_g_points pgp
448: WHERE hsck.soft_coding_keyflex_id(+) = paa.soft_coding_keyflex_id
449: AND paa.assignment_id = p_assignment_id
450: AND pkg.grade_id (+) = hsck.segment4 -- This segement4 stores the grade_id

Line 464: l_second_grade per_kr_grades.grade_name%TYPE;

460: WHERE prtl.run_type_id = p_run_type_id;
461:
462: l_kr_job_title VARCHAR2(150):=null;
463: l_kr_seniority VARCHAR2(150):=null;
464: l_second_grade per_kr_grades.grade_name%TYPE;
465: l_grade_point per_kr_g_points.grade_point_name%TYPE;
466: l_kr_run_type_name pay_run_types_f_vl.run_type_name%TYPE;
467: l_action_info_id NUMBER;
468: l_ovn NUMBER;