APPS.GMS_MULTI_FUNDING dependencies on GMS_AWARDS_ALL

Line 1741: GMS_AWARDS_ALL

1737: St_award_id,
1738: St_revenue_distribution_rule,
1739: St_billing_distribution_rule
1740: FROM
1741: GMS_AWARDS_ALL
1742: WHERE
1743: AGREEMENT_ID = X_Agreement_Id
1744: and award_template_flag = 'DEFERRED';
1745:

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';

Line 3111: FROM gms_awards_all

3107: --Get the org_id from award_project_id being passed
3108: --Set the ORg context
3109: SELECT org_id
3110: INTO l_org_id
3111: FROM gms_awards_all
3112: WHERE award_id = X_award_id;
3113:
3114: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
3115: --End of Shared Service enhancement