DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 380: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;

376: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
377: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
378:
379: /* Bug 5631763 */
380: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
381: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
382: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;
383: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
384: /* Bug 5631763 */

Line 381: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;

377: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
378:
379: /* Bug 5631763 */
380: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
381: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
382: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;
383: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
384: /* Bug 5631763 */
385:

Line 382: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;

378:
379: /* Bug 5631763 */
380: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
381: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
382: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;
383: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
384: /* Bug 5631763 */
385:
386: -- Added for R12 ...

Line 383: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;

379: /* Bug 5631763 */
380: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
381: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
382: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;
383: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
384: /* Bug 5631763 */
385:
386: -- Added for R12 ...
387: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;

Line 5890: pa_budgetary_control_options pb,

5886: FROM
5887: pa_bc_packets pbc,
5888: pa_budget_versions pbv,
5889: pa_budget_entry_methods pm,
5890: pa_budgetary_control_options pb,
5891: pa_projects_all pp,
5892: pa_resource_list_members rlm,
5893: PA_RESOURCE_LISTS_ALL_BG list
5894: WHERE pbc.packet_id = p_packet_id

Line 6794: are defaulted from those defined in pa_budgetary_control_options. If the funds control defined

6790: AND decode(pbc.parent_member_id,0,-1,NVL(pbc.parent_member_id,-1)) = -1
6791: AND NVL(pbc.resource_list_member_id,0) = 0;
6792:
6793: /* Bug 5631763 : If there exists no BC records for the resource group/resource then the funds control levels
6794: are defaulted from those defined in pa_budgetary_control_options. If the funds control defined
6795: in pa_budgetary_control_options for the resource group/resource is "Default from Resource List"
6796: then the funds control levels are derived appropriately from the resource list. */
6797: CURSOR c_res_resgrp_no_bc (c_resource_list_member_id NUMBER) IS
6798: select nvl(rlm.funds_control_level_code,'N')

Line 6795: in pa_budgetary_control_options for the resource group/resource is "Default from Resource List"

6791: AND NVL(pbc.resource_list_member_id,0) = 0;
6792:
6793: /* Bug 5631763 : If there exists no BC records for the resource group/resource then the funds control levels
6794: are defaulted from those defined in pa_budgetary_control_options. If the funds control defined
6795: in pa_budgetary_control_options for the resource group/resource is "Default from Resource List"
6796: then the funds control levels are derived appropriately from the resource list. */
6797: CURSOR c_res_resgrp_no_bc (c_resource_list_member_id NUMBER) IS
6798: select nvl(rlm.funds_control_level_code,'N')
6799: from PA_RESOURCE_LIST_MEMBERS rlm

Line 8120: pa_budgetary_control_options pb

8116: pbc.budget_ccid
8117: FROM pa_bc_packets pbc,
8118: pa_budget_versions bv,
8119: pa_budget_entry_methods pm,
8120: pa_budgetary_control_options pb
8121: WHERE pbc.packet_id = p_packet_id
8122: AND pbc.budget_version_id = bv.budget_version_id
8123: AND bv.budget_entry_method_code = pm.budget_entry_method_code
8124: AND pbc.status_code in ('P','L')

Line 8155: from pa_budgetary_control_options pb,

8151: select fund_control_level_project,
8152: fund_control_level_task ,
8153: fund_control_level_res_grp,
8154: fund_control_level_res
8155: from pa_budgetary_control_options pb,
8156: pa_budget_versions pv
8157: where pv.project_id = pb.project_id
8158: AND pb.BDGT_CNTRL_FLAG = 'Y'
8159: AND pb.BUDGET_TYPE_CODE = pv.budget_type_code