APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 958: FROM AHL_MR_EFFECTIVITIES

954: FND_MSG_PUB.ADD;
955: END IF;
956:
957: SELECT COUNT(*) INTO l_counter
958: FROM AHL_MR_EFFECTIVITIES
959: WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID
960: AND ((PROGRAM_DURATION IS NOT NULL OR PROGRAM_DURATION_UOM_CODE IS NOT NULL)
961: AND THRESHOLD_DATE IS NOT NULL);
962:

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 1157: from ahl_mr_effectivities

1153: c_mr_header_id number
1154: )
1155: IS
1156: select 'x'
1157: from ahl_mr_effectivities
1158: where mr_header_id = c_mr_header_id;
1159:
1160: l_dummy_char varchar2(1);
1161: l_old_prog_type varchar2(30);

Line 2350: Select * from ahl_mr_Effectivities

2346: l_mr_route_rec CurGetRoutes%rowtype;
2347:
2348: Cursor curGetMrEffects(c_mr_header_id number)
2349: Is
2350: Select * from ahl_mr_Effectivities
2351: Where mr_header_id=c_mr_header_id;
2352: L_MR_EFFECT_REC curGetMrEffects%ROWTYPE;
2353:
2354: Cursor curGetMrEffDetls(c_mr_effectivity_id number)

Line 2445: Delete AHL_MR_EFFECTIVITIES

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;
2448:
2449: End loop;