APPS.PSB_BUDGET_GROUPS_PVT dependencies on PSB_BUDGET_GROUPS_V

Line 398: from PSB_BUDGET_GROUPS_V

394: l_freeze_flag VARCHAR2(1);
395:
396: cursor c_FreezeFlag is
397: select nvl(freeze_hierarchy_flag, root_freeze_hierarchy_flag) freeze_hierarchy_flag
398: from PSB_BUDGET_GROUPS_V
399: where budget_group_id = p_budget_group_id;
400:
401: BEGIN
402:

Line 610: from PSB_BUDGET_GROUPS_V

606: l_return_status VARCHAR2(1);
607:
608: cursor c_Flex is
609: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) flex_code
610: from PSB_BUDGET_GROUPS_V
611: where budget_group_id = p_budget_group_id;
612:
613: BEGIN
614:

Line 3427: FROM psb_budget_groups_v

3423:
3424: CURSOR c_top_level_bg IS
3425: SELECT budget_group_id,PS_ACCOUNT_POSITION_SET_ID,
3426: NPS_ACCOUNT_POSITION_SET_ID,name,chart_of_accounts_id
3427: FROM psb_budget_groups_v
3428: WHERE root_budget_group = 'Y'
3429: AND (((p_budget_group_id is not null) and
3430: (budget_group_id = p_budget_group_id))
3431: or (p_budget_group_id is null));

Line 3729: psb_budget_groups_v b

3725: cursor c_Missing_Accounts IS
3726: SELECT a.code_combination_id ccid,b.name bg_name ,s.name set_name
3727: FROM psb_budget_accounts a,
3728: psb_set_relations_v s,
3729: psb_budget_groups_v b
3730: WHERE b.budget_group_id = s.budget_group_id
3731: AND b.budget_group_type = 'R'
3732: AND nvl(b.root_budget_group_id, b.budget_group_id) = p_top_budget_group_id
3733: AND s.account_position_set_id = a.account_position_set_id

Line 3864: FROM psb_budget_groups_v

3860:
3861:
3862: cursor c_Missing_org IS
3863: SELECT budget_group_id ,short_name
3864: FROM psb_budget_groups_v
3865: WHERE budget_group_type = 'R'
3866: AND nvl(root_budget_group_id, budget_group_id) =
3867: p_top_budget_group_id
3868: AND organization_id is null;

Line 3871: FROM psb_budget_groups_v

3867: p_top_budget_group_id
3868: AND organization_id is null;
3869: cursor c_Missing_Top_org IS
3870: SELECT budget_group_id, short_name
3871: FROM psb_budget_groups_v
3872: WHERE budget_group_type = 'R'
3873: AND budget_group_id = p_top_budget_group_id
3874: AND business_group_id is null;
3875:

Line 3879: FROM psb_budget_groups_v bg

3875:
3876:
3877: cursor c_Invalid_ORG IS
3878: SELECT budget_group_id, bg.short_name
3879: FROM psb_budget_groups_v bg
3880: WHERE budget_group_type = 'R'
3881: AND root_budget_group_id = p_top_budget_group_id
3882: AND nvl(root_budget_group,'N') = 'N'
3883: and not exists