DBA Data[Home] [Help]

APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_SUMMARY_PROJECT_FUNDINGS

Line 59: FROM gms_summary_project_fundings gspf,gms_installments gi

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;

Line 181: FROM gms_summary_project_fundings gspf,gms_installments gi

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: