APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 8578: FROM ahl_unit_effectivities_app_v UE, ahl_unit_deferrals_b UDF, ahl_mr_headers_b MR

8574: UE.DEFER_FROM_UE_ID,
8575: nvl(MR.whichever_first_code, 'FIRST') whichever_first_code,
8576: UDF.unit_deferral_type, UE.CS_INCIDENT_ID, UDF.DEFERRAL_EFFECTIVE_ON,
8577: UDF.AFFECT_DUE_CALC_FLAG, UDF.SET_DUE_DATE, UDF.unit_deferral_id
8578: FROM ahl_unit_effectivities_app_v UE, ahl_unit_deferrals_b UDF, ahl_mr_headers_b MR
8579: WHERE UE.defer_from_ue_id = UDF.unit_effectivity_id
8580: AND UE.mr_header_id = MR.mr_header_id(+)
8581: AND csi_item_instance_id = p_csi_item_instance_id
8582: AND status_code IS NULL

Line 8583: --AND defer_from_ue_id IS NOT NULL -- not required as joining table ahl_unit_deferrals_b

8579: WHERE UE.defer_from_ue_id = UDF.unit_effectivity_id
8580: AND UE.mr_header_id = MR.mr_header_id(+)
8581: AND csi_item_instance_id = p_csi_item_instance_id
8582: AND status_code IS NULL
8583: --AND defer_from_ue_id IS NOT NULL -- not required as joining table ahl_unit_deferrals_b
8584: AND UDF.unit_deferral_type IN ('DEFERRAL', 'MEL','CDL')
8585: AND NOT EXISTS (SELECT 'x'
8586: FROM ahl_ue_relationships
8587: WHERE related_ue_id = UE.unit_effectivity_id

Line 8596: FROM ahl_unit_deferrals_b

8592: /* Commented as we retrieve this info in ahl_deferred_ue_csr
8593: -- Get deferral detail from ahl_unit_deferrals.
8594: CURSOR ahl_unit_deferral_csr (p_deferred_from_ue_id IN NUMBER) IS
8595: SELECT AFFECT_DUE_CALC_FLAG, SET_DUE_DATE, unit_deferral_id, deferral_effective_on
8596: FROM ahl_unit_deferrals_b
8597: WHERE unit_effectivity_id = p_deferred_from_ue_id
8598: AND unit_deferral_type = 'DEFERRAL';
8599: */
8600: