APPS.GMS_AP_API dependencies on GMS_SUMMARY_PROJECT_FUNDINGS

Line 705: gms_summary_project_fundings pf

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 ;
709:

Line 718: gms_summary_project_fundings pf

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,
722: gms_summary_project_fundings pf2

Line 722: gms_summary_project_fundings pf2

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 ) ;
726: BEGIN