DBA Data[Home] [Help]

APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on PAY_RUN_TYPES_F_VL

Line 459: FROM pay_run_types_f_vl prtl

455:
456: CURSOR csr_run_type_name(p_run_type_id NUMBER)
457: IS
458: SELECT prtl.run_type_name
459: FROM pay_run_types_f_vl prtl
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;

Line 466: l_kr_run_type_name pay_run_types_f_vl.run_type_name%TYPE;

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:
470: BEGIN