APPS.AHL_FMP_MR_INTERVAL_PVT dependencies on AHL_MR_INTERVALS_V

Line 1201: FROM AHL_MR_INTERVALS_V

1197: CURSOR get_pm_pgm_dup_rec( c_mr_effectivity_id NUMBER )
1198: IS
1199: SELECT counter_id,
1200: counter_name
1201: FROM AHL_MR_INTERVALS_V
1202: WHERE mr_effectivity_id = c_mr_effectivity_id
1203: GROUP BY counter_id,
1204: counter_name
1205: HAVING count(*) > 1;

Line 1215: FROM AHL_MR_INTERVALS_V

1211: start_value,
1212: stop_value,
1213: start_date,
1214: stop_date
1215: FROM AHL_MR_INTERVALS_V
1216: WHERE mr_effectivity_id = c_mr_effectivity_id
1217: GROUP BY counter_id,
1218: counter_name,
1219: start_value,

Line 1231: FROM AHL_MR_INTERVALS_V

1227: SELECT counter_id,
1228: counter_name,
1229: start_date,
1230: stop_date
1231: FROM AHL_MR_INTERVALS_V
1232: WHERE mr_effectivity_id = c_mr_effectivity_id
1233: ORDER BY counter_id,
1234: start_date,
1235: stop_date;

Line 1244: FROM AHL_MR_INTERVALS_V

1240: counter_name,
1241: earliest_due_value,
1242: start_value,
1243: stop_value
1244: FROM AHL_MR_INTERVALS_V
1245: WHERE mr_effectivity_id = c_mr_effectivity_id
1246: ORDER BY counter_id,
1247: start_value,
1248: stop_value;

Line 1253: FROM AHL_MR_INTERVALS_V

1249:
1250: CURSOR check_unique_reset_value( c_mr_effectivity_id NUMBER )
1251: IS
1252: SELECT counter_name
1253: FROM AHL_MR_INTERVALS_V
1254: WHERE mr_effectivity_id = c_mr_effectivity_id
1255: AND reset_value IS NOT NULL
1256: GROUP BY counter_name
1257: HAVING count(*) > 1;