APPS.GMS_REPORT_SF269 dependencies on GMS_CDL_BURDEN_DETAIL_V

Line 51: GMS_CDL_BURDEN_DETAIL_V bv,

47: Select
48: sum(nvl(bv.burden_cost,0)) burden_cost,
49: gcd.report_direct_flag report_direct_flag
50: from gms_awards a,
51: GMS_CDL_BURDEN_DETAIL_V bv,
52: pa_ind_cost_codes cd,
53: gms_ind_cost_codes gcd,
54: gms_allowable_expenditures ae
55: where

Line 326: -- Set current_project_id to NULL to use GMS_CDL_BURDEN_DETAIL_V

322: End;
323:
324: --4. Get total outlays for this report
325:
326: -- Set current_project_id to NULL to use GMS_CDL_BURDEN_DETAIL_V
327: -- for burden costs of all projects
328:
329: -- gms_burden_costing.set_current_project_id (NULL);
330: -- the above line has been commented out for bug 2442827

Line 433: GMS_CDL_BURDEN_DETAIL_V bv,

429: sum(nvl(bv.burden_cost,0)) burden_cost
430: into l_allowed_cost_base_burden
431: from gms_allowable_expenditures ae,
432: gms_awards a,
433: GMS_CDL_BURDEN_DETAIL_V bv,
434: gms_award_distributions g,
435: pa_cost_distribution_lines_all c,
436: pa_expenditure_items ei
437: where g.expenditure_item_id = c.expenditure_item_id