DBA Data[Home] [Help]

APPS.GMS_REPORT_SF269 dependencies on PA_EXPENDITURE_ITEMS

Line 21: from pa_expenditure_items ei,

17: cursor total_outlay_raw IS
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

Line 436: pa_expenditure_items ei

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')
440: and c.gl_date between X_Report_Start_Date and X_Report_End_Date