DBA Data[Home] [Help]

APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_MR_INTERVALS

Line 972: FROM AHL_MR_INTERVALS_APP_V INT,

968:
969: CURSOR get_intervals_rec ( c_mr_effectivity_id NUMBER )
970: IS
971: SELECT DISTINCT INT.counter_id
972: FROM AHL_MR_INTERVALS_APP_V INT,
973: AHL_MR_EFFECTIVITIES_APP_V EF
974: WHERE INT.mr_effectivity_id = EF.mr_effectivity_id
975: AND EF.mr_effectivity_id = c_mr_effectivity_id;
976:

Line 1711: DELETE AHL_MR_INTERVALS

1707: NULL;
1708: END IF;
1709:
1710: -- Delete the record in related Tables
1711: DELETE AHL_MR_INTERVALS
1712: WHERE mr_effectivity_id = p_x_effectivity_tbl(i).mr_effectivity_id;
1713:
1714: -- If the record does not exist, then, Continue.
1715: IF ( SQL%ROWCOUNT = 0 ) THEN