APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_INTERVALS

Line 1101: FROM AHL_MR_EFFECTIVITIES A,AHL_MR_INTERVALS B

1097: FND_MSG_PUB.ADD;
1098: END IF;
1099:
1100: SELECT COUNT(B.MR_INTERVAL_ID) INTO l_counter
1101: FROM AHL_MR_EFFECTIVITIES A,AHL_MR_INTERVALS B
1102: WHERE A.MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID
1103: AND A.MR_EFFECTIVITY_ID=B.MR_EFFECTIVITY_ID;
1104:
1105: IF l_counter >0

Line 2705: Select * from ahl_mr_intervals

2701: Where mr_effectivity_id=c_mr_effectivity_id;
2702:
2703: Cursor curGetMrEffIntervals(c_mr_effectivity_id number)
2704: Is
2705: Select * from ahl_mr_intervals
2706: Where mr_effectivity_id=c_mr_effectivity_id;
2707:
2708: Cursor curGetMrdocAssociations(c_mr_header_id number)
2709: Is

Line 2814: Delete AHL_MR_INTERVALS

2810: Else
2811: Delete AHL_MR_EFFECTIVITY_DTLS
2812: Where MR_effectivity_id=l_mr_effect_rec.MR_EFFECTIVITY_ID;
2813:
2814: Delete AHL_MR_INTERVALS
2815: Where MR_effectivity_id=l_mr_effect_rec.mr_effectivity_id;
2816: Delete AHL_MR_EFFECTIVITIES
2817: Where mr_effectivity_id=l_mr_effect_rec.mr_effectivity_id;
2818: End if;