APPS.GMS_AP_API2 dependencies on GMS_INSTALL

Line 31: from gms_installments ins,

27: -- project.
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 ;

Line 44: from gms_installments ins,

40: -- project charged to a transaction.
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,

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

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
50: where ins2.installment_id = pf2.installment_id
51: and pf2.project_id = pf.project_id
52: and ins2.award_id <> ins.award_id ) ;

Line 358: IF NOT gms_install.enabled THEN

354: -- Start of comment
355: -- Verify that grants is enabled.
356: -- End of comments.
357: --
358: IF NOT gms_install.enabled THEN
359: return ;
360: END IF ;
361:
362: -- Load the collection with the AP inv dist data first.