APPS.GMS_MULTI_FUNDING dependencies on PA_EVENTS

Line 1827: FROM pa_events a,gms_awards_all b

1823: (St_revenue_distribution_rule = 'EVENT' and St_billing_distribution_rule = 'EVENT') THEN
1824: SELECT sum(bill_amount),
1825: sum(revenue_amount)
1826: INTO x_bill_amount, x_revenue_amount
1827: FROM pa_events a,gms_awards_all b
1828: WHERE a.project_id = b.award_project_id
1829: and b.award_id = St_award_id;
1830: if ((x_revenue_amount > x_total_funding_amount)/* or (x_bill_amount > x_total_funding_amount)*/) THEN
1831: X_Err_Code := 'E';