DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on GMS_ENCUMBRANCE_ITEMS

Line 754: from gms_encumbrance_items enc,

750: , nvl(enc.override_to_organization_id,ge.incurred_by_organization_id) expenditure_organization_id
751: , adl.resource_list_member_id
752: , adl.bud_task_id
753: , adl.ind_compiled_set_id
754: from gms_encumbrance_items enc,
755: gms_award_distributions adl,
756: gms_encumbrances_all ge
757: where enc.encumbrance_item_id = adl.expenditure_item_id
758: and nvl(enc.enc_distributed_flag,'N') = 'Y'

Line 2664: FROM gms_encumbrance_items_all enc,

2660: cursor ENC_record is
2661: select nvl(adl.burdenable_raw_cost,0) ,
2662: adl.award_set_id award_set_id,
2663: adl_line_num adl_line_num
2664: FROM gms_encumbrance_items_all enc,
2665: gms_award_distributions adl
2666: where adl.expenditure_item_id = ENC.encumbrance_item_id
2667: and adl.adl_status = 'A'
2668: and ENC.encumbrance_item_id = bc_pkt_rec.document_header_id