[Home] [Help]
2352: L_MR_EFFECT_REC curGetMrEffects%ROWTYPE;
2353:
2354: Cursor curGetMrEffDetls(c_mr_effectivity_id number)
2355: Is
2356: Select * from ahl_mr_effectivity_dtls
2357: Where mr_effectivity_id=c_mr_effectivity_id;
2358:
2359: Cursor curGetMrEffIntervals(c_mr_effectivity_id number)
2360: Is
2436: If CurGetMrEffects%NotFound
2437: Then
2438: Exit;
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;