APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 733: -- for BC enabled projects if encumbrance type in pa_budgetary_control_options is NULL

729: -- R12 Funds management changes --Rshaik
730: -- IN R12, project encumbrance type is no more user enterable in Project
731: -- budgetary control window .This is seeded into gl_encumbrance types
732: -- Hence existing API has been modified to return seeded encumbrance type id
733: -- for BC enabled projects if encumbrance type in pa_budgetary_control_options is NULL
734: -- Also for performance reasons instead of calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options
735: -- have cursor C_BUDGET_CONTROL to fetch required details.
736: -- -------------------------------------------------------------------------------------------+
737:

Line 748: l_encumbrance_type_id PA_BUDGETARY_CONTROL_OPTIONS.encumbrance_type_id%TYPE;

744: SELECT encumbrance_type_id
745: FROM gl_encumbrance_types
746: WHERE encumbrance_type_key = 'Projects';
747:
748: l_encumbrance_type_id PA_BUDGETARY_CONTROL_OPTIONS.encumbrance_type_id%TYPE;
749:
750: BEGIN
751:
752: -- Note:

Line 999: pa_budgetary_control_options pbco

995: into x_base_version_id,x_res_list_id,x_entry_level_code
996: from pa_budget_versions pbv,
997: --pa_budget_types pbt,
998: pa_budget_entry_methods pbm,
999: pa_budgetary_control_options pbco
1000: where pbv.project_id = p_project_id
1001: and pbv.current_flag = 'Y'
1002: and pbv.budget_status_code = 'B'
1003: and pbv.budget_type_code = pbco.budget_type_code

Line 2718: FROM pa_budgetary_control_options

2714: THEN
2715:
2716: SELECT count(*)
2717: INTO l_rec_count
2718: FROM pa_budgetary_control_options
2719: WHERE project_id = p_proj_id
2720: AND bdgt_cntrl_flag = 'Y';
2721:
2722: if l_rec_count >= 1 then