46: p_award_id IN NUMBER,
47: p_report_start_date IN DATE,
48: p_report_end_date IN DATE) IS
49: Select SUM(nvl(c.amount,0))
50: from pa_expenditure_items_all ei,
51: pa_cost_distribution_lines_all c,
52: gms_award_distributions g
53: where --added by rkuttiya for bug 9117372
54: --c.gl_date between p_report_start_date and p_report_end_date