APPS.GMS_AWARDS_DIST_PKG dependencies on GMS_INSTALL

Line 757: FROM gms_installments ins,

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

Line 770: FROM gms_installments ins,

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

Line 775: FROM gms_installments ins2,

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,
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 ) ;

Line 1331: IF NOT gms_install.enabled THEN

1327: -- Start of comment
1328: -- Verify that grants is enabled.
1329: -- End of comments.
1330: --
1331: IF NOT gms_install.enabled THEN
1332: return ;
1333: END IF ;
1334:
1335: IF p_doc_type ='REQ' THEN