DBA Data[Home] [Help]

APPS.GMS_REPORT_SF270 dependencies on GMS_AWARD_DISTRIBUTIONS

Line 102: gms_award_distributions g

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