APPS.GHR_CPDF_EHRIS dependencies on PER_GRADE_DEFINITIONS

Line 1225: -- start_date_active and end_date_active on the PER_GRADE_DEFINITIONS

1221: ,p_sr_report_date IN DATE
1222: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
1223: )
1224: IS
1225: -- start_date_active and end_date_active on the PER_GRADE_DEFINITIONS
1226: -- table WAS NOT considered as a query criteria because all rows on
1227: -- GHRDEV16 had null values for both columns.
1228: l_proc varchar2(30) := 'get_from_history_gradef';
1229: CURSOR GRADEFCUR IS

Line 1232: FROM PER_GRADE_DEFINITIONS

1228: l_proc varchar2(30) := 'get_from_history_gradef';
1229: CURSOR GRADEFCUR IS
1230: SELECT SEGMENT1,
1231: SEGMENT2
1232: FROM PER_GRADE_DEFINITIONS
1233: WHERE GRADE_DEFINITION_ID =
1234: (SELECT MAX(GRADE_DEFINITION_ID)
1235: FROM PER_GRADES
1236: WHERE GRADE_ID = g_grade_id);