APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS_APP_V

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;