55: ) RETURN BOOLEAN AS
56:
57: CURSOR funding_exist IS
58: SELECT 1 --COUNT(*) bug 2355648
59: FROM gms_summary_project_fundings gspf,gms_installments gi
60: WHERE gi.award_id = p_award_Id
61: AND gspf.installment_id=gi.installment_id
62: AND rownum <=1;
63: l_funding_exist NUMBER:=0;
177: errbuff OUT NOCOPY VARCHAR2 ) IS
178:
179: CURSOR GET_PROJECT_ID IS
180: SELECT DISTINCT PROJECT_ID
181: FROM gms_summary_project_fundings gspf,gms_installments gi
182: WHERE gi.award_id = p_award_id --:gms_awards_v.Award_Id bug 2355648
183: AND gspf.installment_id=gi.installment_id;
184:
185: