DBA Data[Home] [Help]

APPS.GMS_REPORT_SF270 dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 101: pa_cost_distribution_lines_all c,

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
105: and g.award_id = X_Award_Id

Line 126: pa_cost_distribution_lines_all c,

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
130: and bv.award_id = X_Award_Id