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;