APPS.PA_BUDGET_UTILS dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 3112: from pa_budgetary_control_options a

3108: into l_dual_bdgt_cntrl_flag
3109: from dual
3110: where exists
3111: (select 1
3112: from pa_budgetary_control_options a
3113: where project_id = p_project_id
3114: and external_budget_code = 'CC'
3115: and bdgt_cntrl_flag = 'Y')
3116: and exists

Line 3118: from pa_budgetary_control_options b

3114: and external_budget_code = 'CC'
3115: and bdgt_cntrl_flag = 'Y')
3116: and exists
3117: (select 1
3118: from pa_budgetary_control_options b
3119: where project_id = p_project_id
3120: and external_budget_code = 'GL'
3121: and bdgt_cntrl_flag = 'Y');
3122: exception

Line 3135: FROM pa_budgetary_control_options pbco

3131: WHERE project_id = p_project_id
3132: AND BUDGET_STATUS_CODE = 'S'
3133: AND budget_type_code =
3134: (SELECT budget_type_code
3135: FROM pa_budgetary_control_options pbco
3136: WHERE pbco.budget_type_code = bv.budget_type_code
3137: AND pbco.project_id = bv.project_id
3138: AND pbco.bdgt_cntrl_flag = 'Y'
3139: AND pbco.external_budget_code = 'CC');