APPS.GMS_AP_API dependencies on GMS_INSTALLMENTS

Line 704: from gms_installments ins,

700: -- project.
701: -- =====================================================
702: cursor c_validate_award is
703: select ins.award_id
704: from gms_installments ins,
705: gms_summary_project_fundings pf
706: where ins.installment_id = pf.installment_id
707: and pf.project_id = p_project_id
708: and ins.award_id = p_award_id ;

Line 717: from gms_installments ins,

713: -- project charged to a transaction.
714: -- =====================================================
715: cursor c_get_award is
716: select ins.award_id
717: from gms_installments ins,
718: gms_summary_project_fundings pf
719: where ins.installment_id = pf.installment_id
720: and pf.project_id = p_project_id
721: and NOT EXISTS ( select 1 from gms_installments ins2,

Line 721: and NOT EXISTS ( select 1 from gms_installments ins2,

717: from gms_installments ins,
718: gms_summary_project_fundings pf
719: where ins.installment_id = pf.installment_id
720: and pf.project_id = p_project_id
721: and NOT EXISTS ( select 1 from gms_installments ins2,
722: gms_summary_project_fundings pf2
723: where ins2.installment_id = pf2.installment_id
724: and pf2.project_id = pf.project_id
725: and ins2.award_id <> ins.award_id ) ;