DBA Data[Home] [Help]

APPS.GMS_REPORT_SF425 dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 51: pa_cost_distribution_lines_all c,

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
55: trunc(c.gl_date) < trunc(p_report_end_date)

Line 96: pa_cost_distribution_lines_all c,

92: nvl(c.amount,0) raw_cost,
93: c.expenditure_item_id,
94: c.line_num
95: from pa_expenditure_items ei,
96: pa_cost_distribution_lines_all c,
97: gms_award_distributions g
98: where g.expenditure_item_id = c.expenditure_item_id
99: and g.cdl_line_num = c.line_num
100: -- rkuttiya added for bug 9117372