APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGETARY_CONTROL_OPTIONS

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

618: -- R12 Funds management changes --Rshaik
619: -- IN R12, project encumbrance type is no more user enterable in Project
620: -- budgetary control window .This is seeded into gl_encumbrance types
621: -- Hence existing API has been modified to return seeded encumbrance type id
622: -- for BC enabled projects if encumbrance type in pa_budgetary_control_options is NULL
623: -- Also for performance reasons instead of calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options
624: -- have cursor C_BUDGET_CONTROL to fetch required details.
625: -- -------------------------------------------------------------------------------------------+
626:

Line 637: l_encumbrance_type_id PA_BUDGETARY_CONTROL_OPTIONS.encumbrance_type_id%TYPE;

633: SELECT encumbrance_type_id
634: FROM gl_encumbrance_types
635: WHERE encumbrance_type_key = 'Projects';
636:
637: l_encumbrance_type_id PA_BUDGETARY_CONTROL_OPTIONS.encumbrance_type_id%TYPE;
638:
639: BEGIN
640:
641: -- Note:

Line 848: pa_budgetary_control_options pbco

844: into x_base_version_id,x_res_list_id,x_entry_level_code
845: from pa_budget_versions pbv,
846: --pa_budget_types pbt,
847: pa_budget_entry_methods pbm,
848: pa_budgetary_control_options pbco
849: where pbv.project_id = p_project_id
850: and pbv.current_flag = 'Y'
851: and pbv.budget_status_code = 'B'
852: and pbv.budget_type_code = pbco.budget_type_code