APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 1088: FROM AHL_MR_EFFECTIVITIES

1084: FND_MSG_PUB.ADD;
1085: END IF;
1086:
1087: SELECT COUNT(*) INTO l_counter
1088: FROM AHL_MR_EFFECTIVITIES
1089: WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID
1090: AND ((PROGRAM_DURATION IS NOT NULL OR PROGRAM_DURATION_UOM_CODE IS NOT NULL)
1091: AND THRESHOLD_DATE IS NOT NULL);
1092:

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

1283: c_mr_header_id number
1284: )
1285: IS
1286: select 'x'
1287: from ahl_mr_effectivities
1288: where mr_header_id = c_mr_header_id;
1289:
1290: l_dummy_char varchar2(1);
1291: l_old_prog_type varchar2(30);

Line 2694: Select * from ahl_mr_Effectivities

2690: l_mr_route_rec CurGetRoutes%rowtype;
2691:
2692: Cursor curGetMrEffects(c_mr_header_id number)
2693: Is
2694: Select * from ahl_mr_Effectivities
2695: Where mr_header_id=c_mr_header_id;
2696: L_MR_EFFECT_REC curGetMrEffects%ROWTYPE;
2697:
2698: Cursor curGetMrEffDetls(c_mr_effectivity_id number)

Line 2816: Delete AHL_MR_EFFECTIVITIES

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;
2819:
2820: End loop;