APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS

Line 2700: Select * from ahl_mr_effectivity_dtls

2696: L_MR_EFFECT_REC curGetMrEffects%ROWTYPE;
2697:
2698: Cursor curGetMrEffDetls(c_mr_effectivity_id number)
2699: Is
2700: Select * from ahl_mr_effectivity_dtls
2701: Where mr_effectivity_id=c_mr_effectivity_id;
2702:
2703: Cursor curGetMrEffIntervals(c_mr_effectivity_id number)
2704: Is

Line 2811: Delete AHL_MR_EFFECTIVITY_DTLS

2807: If CurGetMrEffects%NotFound
2808: Then
2809: Exit;
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;