DBA Data[Home] [Help]

APPS.GMS_AWARDS_DIST_PKG dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 649: from gms_encumbrance_items_all ei

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.

Line 658: from gms_encumbrance_items_all ei

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 ;