APPS.GMS_REPORT_SF269 dependencies on GMS_BUDGET_VERSIONS

Line 36: from gms_budget_versions gbv

32: and c.line_type = 'R'
33: and nvl(ei.system_linkage_function,'XXX') <> 'BTC'
34: --- BUG 4005793 : FPM Perf. fixes.
35: and ei.project_id in ( select gbv.project_id
36: from gms_budget_versions gbv
37: where gbv.budget_type_code = 'AC'
38: and gbv.budget_status_code in ('S','W' )
39: and gbv.award_id = X_award_id );
40:

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')

Line 379: FROM gms_bc_packets gbc, GMS_BUDGET_VERSIONS GBV

375: AND GBV.budget_status_code = 'B'
376: GROUP BY GB.award_id
377: UNION ALL
378: SELECT sum((nvl(gbc.entered_dr,0)- nvl(gbc.entered_cr,0)) * decode(gbc.document_type,'PO',1,'AP',1,'ENC',1,0)) burdened_cost
379: FROM gms_bc_packets gbc, GMS_BUDGET_VERSIONS GBV
380: WHERE gbv.budget_version_id = gbc.budget_version_id
381: AND gbc.status_code = 'A'
382: AND GBV.budget_status_code = 'B'
383: AND GBV.current_flag in ('Y', 'R')