APPS.GMS_BUDGET_BALANCE dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 800: from gms_encumbrance_items_all gei,

796: gei.job_id, -- Bug 2069132 ( RLMI Change)
797: pet.expenditure_category, -- Bug 2069132 ( RLMI Change)
798: pet.revenue_category_code, -- Bug 2069132 ( RLMI Change)
799: adl.ind_compiled_set_id -- Bug 2387678 (Performance Tuning)
800: from gms_encumbrance_items_all gei,
801: gms_encumbrances_all ge,
802: gl_period_STATUSES gl,
803: --pa_tasks task, -- commented out NOCOPY for porting bug:1703510
804: gms_award_distributions adl,

Line 1355: gms_encumbrance_items_all ei

1351: from gms_bc_packets gms,
1352: gms_budget_versions bv,
1353: pa_budget_entry_methods pm,
1354: pa_expenditure_types TYPE,
1355: gms_encumbrance_items_all ei
1356: where gms.packet_id = x_packet_id
1357: and gms.budget_version_id = bv.budget_version_id
1358: and gms.document_type = 'ENC'
1359: and bv.budget_entry_method_code = pm.budget_entry_method_code

Line 1487: gms_encumbrance_items_all item,

1483: item.job_id
1484: INTO x_person_id,
1485: x_job_id
1486: FROM gms_encumbrances_all enc,
1487: gms_encumbrance_items_all item,
1488: gms_bc_packets bc
1489: WHERE bc.packet_id = x_packet_id
1490: AND bc.bc_packet_id = x_bc_packet_id
1491: AND bc.document_header_id = item.encumbrance_item_id