DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on GMS_ENCUMBRANCE_ITEMS

Line 487: from gms_encumbrance_items enc,

483: , nvl(enc.override_to_organization_id,ge.incurred_by_organization_id) expenditure_organization_id
484: , adl.resource_list_member_id
485: , adl.bud_task_id
486: , adl.ind_compiled_set_id
487: from gms_encumbrance_items enc,
488: gms_award_distributions adl,
489: gms_encumbrances_all ge
490: where enc.encumbrance_item_id = adl.expenditure_item_id
491: and nvl(enc.enc_distributed_flag,'N') = 'Y'

Line 2397: FROM gms_encumbrance_items_all enc,

2393: cursor ENC_record is
2394: select nvl(adl.burdenable_raw_cost,0) ,
2395: adl.award_set_id award_set_id,
2396: adl_line_num adl_line_num
2397: FROM gms_encumbrance_items_all enc,
2398: gms_award_distributions adl
2399: where adl.expenditure_item_id = ENC.encumbrance_item_id
2400: and adl.adl_status = 'A'
2401: and ENC.encumbrance_item_id = bc_pkt_rec.document_header_id