APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 77: PA_Budgetary_Control_Options BCO

73: l_Budget_Entry_Level_Code
74: FROM
75: PA_Budget_versions BVER,
76: PA_Budget_Entry_Methods BEM,
77: PA_Budgetary_Control_Options BCO
78: WHERE
79: BVER.Budget_Version_ID = p_Budget_version_Id
80: AND BEM.Budget_Entry_Method_Code = BVER.Budget_Entry_Method_Code
81: AND BCO.Budget_Type_Code = BVER.Budget_Type_Code

Line 160: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;

156: l_Project_End_Date DATE;
157:
158: l_Msg_Index_Out NUMBER;
159:
160: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
161: l_budget_amount_code Pa_Budget_Types.Budget_Amount_Code%TYPE ;
162:
163: l_is_cc_budget varchar2(1); --Bug 6524116
164: -----------------------------------------------------------------------+

Line 227: From PA_BUDGETARY_CONTROL_OPTIONS PBCO ,

223:
224: Cursor c_Budget_funds is
225: Select PBCO.Balance_type,
226: PBT.Budget_Amount_Code
227: From PA_BUDGETARY_CONTROL_OPTIONS PBCO ,
228: PA_BUDGET_VERSIONS PBV ,
229: PA_BUDGET_TYPES PBT
230: WHERE PBCO.Project_Id = p_project_id
231: AND PBV.Budget_version_id = p_Budget_version_id

Line 612: FROM pa_budgetary_control_options

608:
609: begin
610: SELECT 'Y'
611: INTO l_is_cc_budget
612: FROM pa_budgetary_control_options
613: WHERE project_id = p_Project_ID
614: AND Budget_Type_Code = p_Budget_Type_Code
615: AND EXTERNAL_BUDGET_CODE = 'CC'
616: AND BDGT_CNTRL_FLAG = 'Y';

Line 1477: FROM PA_BUDGETARY_CONTROL_OPTIONS PBCO,

1473: THEN
1474:
1475: SELECT PBCO.boundary_code
1476: INTO l_boundary_code
1477: FROM PA_BUDGETARY_CONTROL_OPTIONS PBCO,
1478: PA_BUDGET_VERSIONS PBV
1479: WHERE PBV.Project_Id = p_project_id
1480: AND PBV.Budget_version_id = p_Budget_version_id
1481: AND PBCO.Project_id = PBV.Project_id