DBA Data[Home] [Help]

APPS.GMS_AWARDS_DIST_PKG dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 629: from gms_encumbrance_items_all ei

625: -- =====
626: delete from gms_award_distributions adls
627: where document_type = 'ENC'
628: and expenditure_item_id in ( select encumbrance_item_id
629: from gms_encumbrance_items_all ei
630: where encumbrance_item_id = p_doc_distribution_id ) ;
631: ELSE
632: -- =====
633: -- Delete award distribution line for a given encumbrance.

Line 638: from gms_encumbrance_items_all ei

634: -- =====
635: delete from gms_award_distributions adls
636: where document_type = 'ENC'
637: and expenditure_item_id in ( select encumbrance_item_id
638: from gms_encumbrance_items_all ei
639: where encumbrance_id = p_doc_header_id ) ;
640:
641: END IF ;
642: END IF ;