DBA Data[Home] [Help]

APPS.GMS_ENC_ADJUSTMENTS dependencies on GMS_AWARD_DISTRIBUTIONS

Line 391: from gms_award_distributions adl ,gms_encumbrance_items ei,gms_encumbrances es

387: FOR EI IN getEI LOOP
388:
389: Begin
390: select award_id into P_Award_Id
391: from gms_award_distributions adl ,gms_encumbrance_items ei,gms_encumbrances es
392: where adl.expenditure_item_id = ei.encumbrance_item_id
393: and ei.encumbrance_id = es.encumbrance_id
394: and es.encumbrance_id = X_orig_enc_id
395: and adl.document_type = 'ENC'