645: -- =====
646: delete from gms_award_distributions adls
647: where document_type = 'ENC'
648: and expenditure_item_id in ( select encumbrance_item_id
649: from gms_encumbrance_items_all ei
650: where encumbrance_item_id = p_doc_distribution_id ) ;
651: ELSE
652: -- =====
653: -- Delete award distribution line for a given encumbrance.
654: -- =====
655: delete from gms_award_distributions adls
656: where document_type = 'ENC'
657: and expenditure_item_id in ( select encumbrance_item_id
658: from gms_encumbrance_items_all ei
659: where encumbrance_id = p_doc_header_id ) ;
660:
661: END IF ;
662: END IF ;