APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_OWNER_DETAILS_V
Line 1562: FROM AHL_MR_EFFECTIVITY_EXT_DTLS EFFEXT, ahl_owner_details_v OWN
1558: IS
1559: SELECT EFFEXT.OWNER_ID,
1560: OWN.owner_number
1561: ,EFFEXT.EFFECT_EXT_DTL_REC_TYPE 1562: FROM AHL_MR_EFFECTIVITY_EXT_DTLS EFFEXT, ahl_owner_details_v OWN 1563: WHERE EFFEXT.mr_effectivity_id = c_mr_effectivity_id
1564: AND EFFEXT.OWNER_ID = OWN.owner_id
1565: AND EFFECT_EXT_DTL_REC_TYPE = 'OWNER'
1566: GROUP BY EFFEXT.OWNER_ID,