DBA Data[Home] [Help]

APPS.GMS_REPORT_SF272 dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 122: pa_cost_distribution_lines_all c,

118: --
119: cursor c_sum_amount is
120: Select SUM(nvl(c.amount,0))
121: from pa_expenditure_items_all ei,
122: pa_cost_distribution_lines_all c,
123: gms_award_distributions g
124: where c.gl_date between X_Report_Start_Date and X_Report_End_Date
125: and c.expenditure_item_id = ei.expenditure_item_id
126: and g.award_id = X_Award_Id

Line 145: pa_cost_distribution_lines_all c,

141:
142: cursor c_sum_burden is
143: Select sum(nvl(bv.burden_cost,0))
144: from pa_expenditure_items_all ei,
145: pa_cost_distribution_lines_all c,
146: gms_cdl_burden_detail_v bv
147: where c.gl_date between X_Report_Start_Date and X_Report_End_Date
148: and c.expenditure_item_id = ei.expenditure_item_id
149: and bv.award_id = X_Award_Id