APPS.GHR_CPDF_STATRPT dependencies on PER_GRADE_DEFINITIONS

Line 587: -- start_date_active and end_date_active on the PER_GRADE_DEFINITIONS

583: ,p_sr_report_date IN DATE
584: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
585: )
586: IS
587: -- start_date_active and end_date_active on the PER_GRADE_DEFINITIONS
588: -- table WAS NOT considered as a query criteria because all rows on
589: -- GHRDEV16 had null values for both columns.
590: l_proc varchar2(30) := 'get_from_history_gradef';
591: CURSOR GRADEFCUR IS

Line 594: FROM PER_GRADE_DEFINITIONS

590: l_proc varchar2(30) := 'get_from_history_gradef';
591: CURSOR GRADEFCUR IS
592: SELECT SEGMENT1,
593: SEGMENT2
594: FROM PER_GRADE_DEFINITIONS
595: WHERE GRADE_DEFINITION_ID =
596: (SELECT MAX(GRADE_DEFINITION_ID)
597: FROM PER_GRADES
598: WHERE GRADE_ID = g_grade_id);