APPS.PSB_BUDGET_GROUPS_PVT dependencies on PSB_SET_RELATIONS

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 63: psb_set_relations c

59: Start_Date DATE,
60: End_Date DATE) is
61: select a.code_combination_id
62: from psb_budget_accounts a,
63: psb_set_relations c
64: where a.account_position_set_id = c.account_position_set_id
65: and ((((End_Date is not null)
66: and ((c.effective_start_date <= End_Date)
67: and (c.effective_end_date is null))

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 100: and used the table psb_set_relations. Also substituted

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,
104: BudgetGroup_ID NUMBER,

Line 113: psb_set_relations a

109: Def_Seg IN VARCHAR2 DEFAULT 'X') is
110: select 'ACCOUNT RANGE OVERLAP'
111: from psb_account_position_set_lines cmp,
112: psb_account_position_set_lines lst,
113: psb_set_relations a
114: where (
115: NVL(cmp.SEGMENT30_LOW,Def_Seg) <= NVL(lst.SEGMENT30_HIGH,Def_Seg)
116: AND NVL(cmp.SEGMENT30_HIGH,Def_Seg) >= NVL(lst.SEGMENT30_LOW,Def_Seg)
117: AND NVL(cmp.SEGMENT29_LOW,Def_Seg) <= NVL(lst.SEGMENT29_HIGH,Def_Seg)

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 2602: delete psb_set_relations where budget_group_id = c1rec.budget_group_id;

2598: delete psb_budget_group_resp where budget_group_id = c1rec.budget_group_id;
2599: if (sql%notfound) then
2600: null;
2601: end if;
2602: delete psb_set_relations where budget_group_id = c1rec.budget_group_id;
2603: if (sql%notfound) then
2604: null;
2605: end if;
2606: delete psb_budget_group_categories where budget_group_id = c1rec.budget_group_id;

Line 2617: delete psb_set_relations where budget_group_id = p_budget_group_id;

2613: delete psb_budget_group_resp where budget_group_id = p_budget_group_id;
2614: if (sql%notfound) then
2615: null;
2616: end if;
2617: delete psb_set_relations where budget_group_id = p_budget_group_id;
2618: if (sql%notfound) then
2619: null;
2620: end if;
2621: delete psb_budget_group_categories where budget_group_id = p_budget_group_id;

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