APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS_APP_V

Line 963: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V EFD,

959:
960: CURSOR get_eff_dtls_rec ( c_mr_effectivity_id NUMBER )
961: IS
962: SELECT DISTINCT EFD.manufacturer_id
963: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V EFD,
964: AHL_MR_EFFECTIVITIES_APP_V EF
965: WHERE EFD.manufacturer_id IS NOT NULL
966: AND EFD.mr_effectivity_id = EF.mr_effectivity_id
967: AND EF.mr_effectivity_id = c_mr_effectivity_id;