DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on GMS_ENCUMBRANCES_ALL

Line 801: gms_encumbrances_all ge,

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,
805: pa_expenditure_types pet -- Bug 2069132 (RLMI Change)

Line 1486: FROM gms_encumbrances_all enc,

1482: SELECT DISTINCT enc.incurred_by_person_id,
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