APPS.GMS_AP_API2 dependencies on GMS_SUMMARY_PROJECT_FUNDINGS

Line 32: gms_summary_project_fundings pf

28: -- =====================================================
29: cursor c_validate_award is
30: select ins.award_id
31: from gms_installments ins,
32: gms_summary_project_fundings pf
33: where ins.installment_id = pf.installment_id
34: and pf.project_id = p_project_id
35: and ins.award_id = p_award_id ;
36:

Line 45: gms_summary_project_fundings pf

41: -- =====================================================
42: cursor c_get_award is
43: select ins.award_id
44: from gms_installments ins,
45: gms_summary_project_fundings pf
46: where ins.installment_id = pf.installment_id
47: and pf.project_id = p_project_id
48: and NOT EXISTS ( select 1 from gms_installments ins2,
49: gms_summary_project_fundings pf2

Line 49: gms_summary_project_fundings pf2

45: gms_summary_project_fundings pf
46: where ins.installment_id = pf.installment_id
47: and pf.project_id = p_project_id
48: and NOT EXISTS ( select 1 from gms_installments ins2,
49: gms_summary_project_fundings pf2
50: where ins2.installment_id = pf2.installment_id
51: and pf2.project_id = pf.project_id
52: and ins2.award_id <> ins.award_id ) ;
53: BEGIN