DBA Data[Home] [Help]

APPS.GMS_REPORT_SF425 dependencies on GMS_BALANCES

Line 149: FROM GMS_BALANCES GB, GMS_BUDGET_VERSIONS GBV

145: p_report_start_date IN DATE,
146: p_report_end_date IN DATE) IS
147: SELECT sum(burdened_cost)
148: FROM (SELECT sum(nvl(GB.encumb_period_to_date,0) * decode(balance_type, 'PO', 1, 'AP' , 1, 'ENC' , 1, 0)) burdened_cost
149: FROM GMS_BALANCES GB, GMS_BUDGET_VERSIONS GBV
150: WHERE gb.award_id = p_award_id
151: AND GBV.award_id = GB.award_id
152: AND GBV.budget_version_id = gb.budget_version_id
153: AND GBV.current_flag in ('Y','R')