DBA Data[Home] [Help]

APPS.GMS_MULTI_FUNDING dependencies on GMS_INSTALLMENTS

Line 842: GMS_INSTALLMENTS c

838: Store_Agreement_Id
839: FROM
840: PA_PROJECTS a,
841: GMS_AWARDS b,
842: GMS_INSTALLMENTS c
843: WHERE
844: c.installment_id = X_Installment_Id and
845: b.Award_Id = c.Award_Id and
846: a.project_id = b.award_project_id;

Line 1804: gms_installments ins

1800: INTO x_total_funding_amount,
1801: x_total_revenue_amount,
1802: x_total_billed_amount
1803: FROM gms_summary_project_fundings gspf,
1804: gms_installments ins
1805: WHERE ins.installment_id = gspf.installment_id
1806: and ins.award_id = St_award_id;
1807:
1808: IF St_revenue_distribution_rule = 'COST' and St_billing_distribution_rule = 'COST' THEN