APPS.AHL_UMP_UTIL_PKG dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 266: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter

262: p_mr_header_id IN NUMBER) IS
263: SELECT ue.accomplished_date, ue.unit_effectivity_id, ue.status_code,
264: decode(ue.status_code, 'TERMINATED', ter.affect_due_calc_flag, def.affect_due_calc_flag),
265: decode(ue.status_code, 'TERMINATED', ter.deferral_effective_on, def.deferral_effective_on)
266: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter
267: WHERE ue.defer_from_ue_id = def.unit_effectivity_id (+)
268: AND ue.unit_effectivity_id = ter.unit_effectivity_id(+)
269: AND ue.status_code IN ('ACCOMPLISHED','INIT-ACCOMPLISHED','TERMINATED')
270: AND ue.csi_item_instance_id = p_csi_item_instance_id

Line 969: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def

965: CURSOR ahl_unit_effectivities_csr (p_csi_item_instance_id IN NUMBER,
966: p_mr_header_id IN NUMBER) IS
967: SELECT ue.accomplished_date, ue.unit_effectivity_id, ue.status_code,
968: affect_due_calc_flag, deferral_effective_on
969: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def
970: WHERE ue.defer_from_ue_id = def.unit_effectivity_id (+)
971: AND ue.status_code IN ('ACCOMPLISHED','INIT-ACCOMPLISHED')
972: AND ue.csi_item_instance_id = p_csi_item_instance_id
973: AND ue.mr_header_id = p_mr_header_id