APPS.AHL_FMP_MR_INTERVAL_PVT dependencies on AHL_MR_INTERVALS_V

Line 1245: FROM AHL_MR_INTERVALS_V

1241: CURSOR get_pm_pgm_dup_rec( c_mr_effectivity_id NUMBER )
1242: IS
1243: SELECT counter_id,
1244: counter_name
1245: FROM AHL_MR_INTERVALS_V
1246: WHERE mr_effectivity_id = c_mr_effectivity_id
1247: GROUP BY counter_id,
1248: counter_name
1249: HAVING count(*) > 1;

Line 1259: FROM AHL_MR_INTERVALS_V

1255: start_value,
1256: stop_value,
1257: start_date,
1258: stop_date
1259: FROM AHL_MR_INTERVALS_V
1260: WHERE mr_effectivity_id = c_mr_effectivity_id
1261: GROUP BY counter_id,
1262: counter_name,
1263: start_value,

Line 1275: FROM AHL_MR_INTERVALS_V

1271: SELECT counter_id,
1272: counter_name,
1273: start_date,
1274: stop_date
1275: FROM AHL_MR_INTERVALS_V
1276: WHERE mr_effectivity_id = c_mr_effectivity_id
1277: ORDER BY counter_id,
1278: start_date,
1279: stop_date;

Line 1288: FROM AHL_MR_INTERVALS_V

1284: counter_name,
1285: earliest_due_value,
1286: start_value,
1287: stop_value
1288: FROM AHL_MR_INTERVALS_V
1289: WHERE mr_effectivity_id = c_mr_effectivity_id
1290: ORDER BY counter_id,
1291: start_value,
1292: stop_value;

Line 1297: FROM AHL_MR_INTERVALS_V

1293:
1294: CURSOR check_unique_reset_value( c_mr_effectivity_id NUMBER )
1295: IS
1296: SELECT counter_name
1297: FROM AHL_MR_INTERVALS_V
1298: WHERE mr_effectivity_id = c_mr_effectivity_id
1299: AND reset_value IS NOT NULL
1300: GROUP BY counter_name
1301: HAVING count(*) > 1;