APPS.GMS_AP_API dependencies on GMS_SUMMARY_PROJECT_FUNDINGS

Line 634: gms_summary_project_fundings pf

630: -- =====================================================
631: cursor c_validate_award is
632: select ins.award_id
633: from gms_installments ins,
634: gms_summary_project_fundings pf
635: where ins.installment_id = pf.installment_id
636: and pf.project_id = p_project_id
637: and ins.award_id = p_award_id ;
638:

Line 647: gms_summary_project_fundings pf

643: -- =====================================================
644: cursor c_get_award is
645: select ins.award_id
646: from gms_installments ins,
647: gms_summary_project_fundings pf
648: where ins.installment_id = pf.installment_id
649: and pf.project_id = p_project_id
650: and NOT EXISTS ( select 1 from gms_installments ins2,
651: gms_summary_project_fundings pf2

Line 651: gms_summary_project_fundings pf2

647: gms_summary_project_fundings pf
648: where ins.installment_id = pf.installment_id
649: and pf.project_id = p_project_id
650: and NOT EXISTS ( select 1 from gms_installments ins2,
651: gms_summary_project_fundings pf2
652: where ins2.installment_id = pf2.installment_id
653: and pf2.project_id = pf.project_id
654: and ins2.award_id <> ins.award_id ) ;
655: BEGIN