APPS.GHR_CPDF_STATRPT dependencies on PER_GRADE_DEFINITIONS

Line 617: -- start_date_active and end_date_active on the PER_GRADE_DEFINITIONS

613: ,p_sr_report_date IN DATE
614: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
615: )
616: IS
617: -- start_date_active and end_date_active on the PER_GRADE_DEFINITIONS
618: -- table WAS NOT considered as a query criteria because all rows on
619: -- GHRDEV16 had null values for both columns.
620: l_proc varchar2(30) := 'get_from_history_gradef';
621: CURSOR GRADEFCUR IS

Line 624: FROM PER_GRADE_DEFINITIONS

620: l_proc varchar2(30) := 'get_from_history_gradef';
621: CURSOR GRADEFCUR IS
622: SELECT SEGMENT1,
623: SEGMENT2
624: FROM PER_GRADE_DEFINITIONS
625: WHERE GRADE_DEFINITION_ID =
626: (SELECT MAX(GRADE_DEFINITION_ID)
627: FROM PER_GRADES
628: WHERE GRADE_ID = g_grade_id);