APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS

Line 890: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V EFD,

886:
887: CURSOR get_eff_dtls_rec ( c_mr_effectivity_id NUMBER )
888: IS
889: SELECT DISTINCT EFD.manufacturer_id
890: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V EFD,
891: AHL_MR_EFFECTIVITIES_APP_V EF
892: WHERE EFD.manufacturer_id IS NOT NULL
893: AND EFD.mr_effectivity_id = EF.mr_effectivity_id
894: AND EF.mr_effectivity_id = c_mr_effectivity_id;

Line 1607: DELETE AHL_MR_EFFECTIVITY_DTLS

1603: FND_MSG_PUB.add;
1604: END IF;
1605:
1606: -- Delete the record in related Tables
1607: DELETE AHL_MR_EFFECTIVITY_DTLS
1608: WHERE mr_effectivity_id = p_x_effectivity_tbl(i).mr_effectivity_id;
1609:
1610: -- If the record does not exist, then, Continue.
1611: IF ( SQL%ROWCOUNT = 0 ) THEN