APPS.PA_BUDGET_UTILS dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 3116: from pa_budgetary_control_options a

3112: into l_dual_bdgt_cntrl_flag
3113: from dual
3114: where exists
3115: (select 1
3116: from pa_budgetary_control_options a
3117: where project_id = p_project_id
3118: and external_budget_code = 'CC'
3119: and bdgt_cntrl_flag = 'Y')
3120: and exists

Line 3122: from pa_budgetary_control_options b

3118: and external_budget_code = 'CC'
3119: and bdgt_cntrl_flag = 'Y')
3120: and exists
3121: (select 1
3122: from pa_budgetary_control_options b
3123: where project_id = p_project_id
3124: and external_budget_code = 'GL'
3125: and bdgt_cntrl_flag = 'Y');
3126: exception

Line 3139: FROM pa_budgetary_control_options pbco

3135: WHERE project_id = p_project_id
3136: AND BUDGET_STATUS_CODE = 'S'
3137: AND budget_type_code =
3138: (SELECT budget_type_code
3139: FROM pa_budgetary_control_options pbco
3140: WHERE pbco.budget_type_code = bv.budget_type_code
3141: AND pbco.project_id = bv.project_id
3142: AND pbco.bdgt_cntrl_flag = 'Y'
3143: AND pbco.external_budget_code = 'CC');