APPS.GHR_CPDF_EHRIS dependencies on PER_GRADE_DEFINITIONS

Line 1271: -- start_date_active and end_date_active on the PER_GRADE_DEFINITIONS

1267: ,p_sr_report_date IN DATE
1268: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
1269: )
1270: IS
1271: -- start_date_active and end_date_active on the PER_GRADE_DEFINITIONS
1272: -- table WAS NOT considered as a query criteria because all rows on
1273: -- GHRDEV16 had null values for both columns.
1274: l_proc varchar2(30) := 'get_from_history_gradef';
1275: CURSOR GRADEFCUR IS

Line 1278: FROM PER_GRADE_DEFINITIONS

1274: l_proc varchar2(30) := 'get_from_history_gradef';
1275: CURSOR GRADEFCUR IS
1276: SELECT SEGMENT1,
1277: SEGMENT2
1278: FROM PER_GRADE_DEFINITIONS
1279: WHERE GRADE_DEFINITION_ID =
1280: (SELECT MAX(GRADE_DEFINITION_ID)
1281: FROM PER_GRADES
1282: WHERE GRADE_ID = g_grade_id);