23: FROM DUAL
24: WHERE EXISTS
25: (SELECT 'X'
26: FROM gl_budgets b1,
27: gl_budget_versions bv1,
28: gl_budorg_bc_options ba,
29: gl_period_statuses pf1,
30: gl_period_statuses pl1,
31: gl_budgets b2,
28: gl_budorg_bc_options ba,
29: gl_period_statuses pf1,
30: gl_period_statuses pl1,
31: gl_budgets b2,
32: gl_budget_versions bv2,
33: gl_period_statuses pf2,
34: gl_period_statuses pl2
35: WHERE b1.current_version_id = bv1.version_num
36: AND b1.budget_name = bv1.budget_name
240: WHERE boundary_code = X_Boundary_Code;
241:
242: CURSOR check_budget_version IS
243: SELECT 'X'
244: FROM GL_BUDGET_VERSIONS
245: WHERE budget_version_id = X_Funding_Budget_Version_Id;
246:
247: L_Range_Id NUMBER;
248: L_Budgetary_Control_Flag VARCHAR2(1);
435: WHERE boundary_code = X_Boundary_Code;
436:
437: CURSOR check_budget_version IS
438: SELECT 'X'
439: FROM GL_BUDGET_VERSIONS
440: WHERE budget_version_id = X_Funding_Budget_Version_Id;
441:
442: L_Range_Id NUMBER;
443: L_Budgetary_Control_Flag VARCHAR2(1);