DBA Data[Home] [Help]

APPS.GMS_REPORT_SF269 dependencies on GMS_BALANCES

Line 370: FROM GMS_BALANCES GB, GMS_BUDGET_VERSIONS GBV

366:
367: CURSOR c_burdened_cost IS
368: SELECT sum(burdened_cost)
369: FROM (SELECT sum(nvl(GB.encumb_period_to_date,0) * decode(balance_type, 'PO', 1, 'AP' , 1, 'ENC' , 1, 0)) burdened_cost
370: FROM GMS_BALANCES GB, GMS_BUDGET_VERSIONS GBV
371: WHERE gb.award_id = x_award_id
372: AND GBV.award_id = GB.award_id
373: AND GBV.budget_version_id = gb.budget_version_id
374: AND GBV.current_flag in ('Y','R')