APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on PER_KR_G_POINTS

Line 447: ,per_kr_g_points pgp

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
451: AND pgp.grade_point_id (+) = hsck.segment5 -- This segement5 stores the grade point id

Line 465: l_grade_point per_kr_g_points.grade_point_name%TYPE;

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;
469: