355: CURSOR c_budctrl_exists checks if there exists any budgetary control records for the project and award. */
356:
357: CURSOR c_budctrl_exists IS
358: SELECT 'Y' 359: FROM DUAL 360: WHERE EXISTS (SELECT 1
361: FROM gms_budgetary_controls bc
362: where bc.project_id = p_project_id
363: and bc.award_id = p_award_id);