DBA Data[Home] [Help]

APPS.GMS_REPORT_SF272 dependencies on GMS_AWARD_DISTRIBUTIONS

Line 123: gms_award_distributions g

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
127: and g.document_type = 'EXP'