APPS.PSB_BUDGET_GROUPS_PVT dependencies on PSB_SET_RELATIONS_V

Line 47: from psb_set_relations_v

43: select account_position_set_id,
44: name,
45: effective_start_date,
46: effective_end_date
47: from psb_set_relations_v
48: where account_or_position_type = 'A'
49: and budget_group_id = BudgetGroup_ID;
50:
51: -- .. cursor of overlap ccid in psb_budget_accounts

Line 99: /* For bug 4991981 --> Removed the view psb_set_relations_v

95: where a.code_combination_id = b.code_combination_id
96: and b.account_position_set_id = AccSet_ID);
97:
98:
99: /* For bug 4991981 --> Removed the view psb_set_relations_v
100: and used the table psb_set_relations. Also substituted
101: bind variables for literals */
102:
103: cursor c_Overlap_Account_Range (RootBudgetGroup_ID NUMBER,

Line 479: psb_set_relations_v c

475: End_Date DATE) is
476: select 'Account Sets Overlap'
477: from psb_budget_accounts a,
478: psb_budget_accounts b,
479: psb_set_relations_v c
480: where a.code_combination_id = b.code_combination_id
481: and b.account_position_set_id = AccSet_ID
482: and a.account_position_set_id = c.account_position_set_id
483: and ((((End_Date is not null)

Line 2816: from psb_set_relations_v

2812: effective_end_date,
2813: account_position_set_id,
2814: attribute_selection_type,
2815: use_in_budget_group_flag
2816: from psb_set_relations_v
2817: where budget_group_id = p_src_budget_group_id;
2818:
2819: Bgsr_Rec BG_SR_Cur%ROWTYPE;
2820:

Line 3618: PSB_SET_RELATIONS_V c,

3614: and gcc.template_id is null
3615: /*For Bug No : 2359795 End*/
3616: and not exists(select 1
3617: from PSB_BUDGET_ACCOUNTS b,
3618: PSB_SET_RELATIONS_V c,
3619: PSB_BUDGET_GROUPS d
3620: where b.code_combination_id = gcc.code_combination_id
3621: and b.account_position_set_id = c.account_position_set_id
3622: and c.budget_group_id = d.budget_group_id

Line 3728: psb_set_relations_v s,

3724:
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