APPS.AHL_COMPLETIONS_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 10963: FROM AHL_UNIT_DEFERRALS_B ORIG_DEF,AHL_UNIT_DEFERRALS_B

10959: WHEN DEF.APPROVAL_STATUS_CODE IS NOT NULL
10960: THEN DEF.APPROVAL_STATUS_CODE
10961: ELSE UE.STATUS_CODE
10962: END)UMP_STATUS_CODE
10963: FROM AHL_UNIT_DEFERRALS_B ORIG_DEF,AHL_UNIT_DEFERRALS_B
10964: DEF,AHL_UNIT_EFFECTIVITIES_APP_V UE
10965: WHERE UE.orig_deferral_ue_id = orig_def.unit_effectivity_id(+)
10966: AND orig_def.unit_deferral_type(+) = 'DEFERRAL'
10967: AND UE.unit_effectivity_id = def.unit_effectivity_id(+)

Line 10986: FROM AHL_UNIT_DEFERRALS_B ORIG_DEF,AHL_UNIT_DEFERRALS_B

10982: WHEN DEF.APPROVAL_STATUS_CODE IS NOT NULL
10983: THEN DEF.APPROVAL_STATUS_CODE
10984: ELSE UE.STATUS_CODE
10985: END)UMP_STATUS_CODE
10986: FROM AHL_UNIT_DEFERRALS_B ORIG_DEF,AHL_UNIT_DEFERRALS_B
10987: DEF,AHL_UNIT_EFFECTIVITIES_APP_V UE
10988: WHERE UE.orig_deferral_ue_id = orig_def.unit_effectivity_id(+)
10989: AND orig_def.unit_deferral_type(+) = 'DEFERRAL'
10990: AND UE.unit_effectivity_id = def.unit_effectivity_id(+)