APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UNIT_EFFECTIVITIES_TL

Line 929: delete from ahl_unit_effectivities_tl

925: END IF;
926:
927: -- added for SB Enh for 'Chain' case
928: BEGIN
929: delete from ahl_unit_effectivities_tl
930: where unit_effectivity_id in (select unit_effectivity_id from ahl_unit_effectivities_b where start_lc_ue_id = l_originator_ue_id);
931:
932: delete from ahl_unit_effectivities_b
933: where start_lc_ue_id = l_originator_ue_id