APPS.GMS_AWARDS_DIST_PKG dependencies on GMS_SUMMARY_PROJECT_FUNDINGS

Line 758: gms_summary_project_fundings pf

754: -- =====================================================
755: CURSOR C_validate_award IS
756: SELECT ins.award_id
757: FROM gms_installments ins,
758: gms_summary_project_fundings pf
759: WHERE ins.installment_id = pf.installment_id
760: AND pf.project_id = p_project_id
761: AND ins.award_id = p_award_id ;
762:

Line 771: gms_summary_project_fundings pf

767: -- =====================================================
768: CURSOR c_get_award IS
769: SELECT ins.award_id
770: FROM gms_installments ins,
771: gms_summary_project_fundings pf
772: WHERE ins.installment_id = pf.installment_id
773: AND pf.project_id = p_project_id
774: AND NOT EXISTS ( SELECT 1
775: FROM gms_installments ins2,

Line 776: gms_summary_project_fundings pf2

772: WHERE ins.installment_id = pf.installment_id
773: AND pf.project_id = p_project_id
774: AND NOT EXISTS ( SELECT 1
775: FROM gms_installments ins2,
776: gms_summary_project_fundings pf2
777: WHERE ins2.installment_id = pf2.installment_id
778: AND pf2.project_id = pf.project_id
779: AND ins2.award_id <> ins.award_id ) ;
780: BEGIN