APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_INTERVALS

Line 971: FROM AHL_MR_EFFECTIVITIES A,AHL_MR_INTERVALS B

967: FND_MSG_PUB.ADD;
968: END IF;
969:
970: SELECT COUNT(B.MR_INTERVAL_ID) INTO l_counter
971: FROM AHL_MR_EFFECTIVITIES A,AHL_MR_INTERVALS B
972: WHERE A.MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID
973: AND A.MR_EFFECTIVITY_ID=B.MR_EFFECTIVITY_ID;
974:
975: IF l_counter >0

Line 2361: Select * from ahl_mr_intervals

2357: Where mr_effectivity_id=c_mr_effectivity_id;
2358:
2359: Cursor curGetMrEffIntervals(c_mr_effectivity_id number)
2360: Is
2361: Select * from ahl_mr_intervals
2362: Where mr_effectivity_id=c_mr_effectivity_id;
2363:
2364: Cursor curGetMrdocAssociations(c_mr_header_id number)
2365: Is

Line 2443: Delete AHL_MR_INTERVALS

2439: Else
2440: Delete AHL_MR_EFFECTIVITY_DTLS
2441: Where MR_effectivity_id=l_mr_effect_rec.MR_EFFECTIVITY_ID;
2442:
2443: Delete AHL_MR_INTERVALS
2444: Where MR_effectivity_id=l_mr_effect_rec.mr_effectivity_id;
2445: Delete AHL_MR_EFFECTIVITIES
2446: Where mr_effectivity_id=l_mr_effect_rec.mr_effectivity_id;
2447: End if;