DBA Data[Home] [Help]

APPS.GMS_REPORT_SF270 dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 100: from pa_expenditure_items_all ei,

96: -- PJ.M:B8:P13:OTH:PERF:INDEX FULL SCAN, NON-MERGABLE VIEW AND HASH JOIN EXISTS
97: --
98: cursor c_sum_amount is
99: Select SUM(nvl(c.amount,0))
100: from pa_expenditure_items_all ei,
101: pa_cost_distribution_lines_all c,
102: gms_award_distributions g
103: where c.gl_date between X_Report_Start_Date and X_Report_End_Date
104: and c.expenditure_item_id = ei.expenditure_item_id

Line 125: from pa_expenditure_items_all ei,

121: --
122: /* --Bug Fix 4940833 :SQL repository Issue
123: cursor c_sum_burden is
124: Select sum(nvl(bv.burden_cost,0))
125: from pa_expenditure_items_all ei,
126: pa_cost_distribution_lines_all c,
127: gms_cdl_burden_detail_v bv
128: where c.gl_date between X_Report_Start_Date and X_Report_End_Date
129: and c.expenditure_item_id = ei.expenditure_item_id