6: x_report_start_date IN DATE,
7: x_report_end_date IN DATE
8: ) IS
9:
10: l_expenditure_item_id1 pa_cost_distribution_lines_all.expenditure_item_id%type;
11: l_line_num1 pa_cost_distribution_lines_all.line_num%type;
12:
13: -- Cursor to Get the the total_outlay from raw cost and burdened cost of expenditure item
14: -- The cursor is split into two for performance reasons
7: x_report_end_date IN DATE
8: ) IS
9:
10: l_expenditure_item_id1 pa_cost_distribution_lines_all.expenditure_item_id%type;
11: l_line_num1 pa_cost_distribution_lines_all.line_num%type;
12:
13: -- Cursor to Get the the total_outlay from raw cost and burdened cost of expenditure item
14: -- The cursor is split into two for performance reasons
15: -- BUG 4005793 : FPM Perf. fixes. |
18: Select nvl(c.amount,0) raw_cost,
19: c.expenditure_item_id ,
20: c.line_num
21: from pa_expenditure_items ei,
22: pa_cost_distribution_lines_all c,
23: gms_award_distributions g
24: where g.expenditure_item_id = c.expenditure_item_id
25: and g.cdl_line_num = c.line_num
26: and c.gl_date between X_Report_Start_Date
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
438: and g.cdl_line_num = c.line_num
439: and c.transfer_status_code in ('A','V')