APPS.PSB_BUDGET_GROUPS_PVT dependencies on PSB_BUDGET_ACCOUNTS

Line 51: -- .. cursor of overlap ccid in psb_budget_accounts

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
52: -- .. used in val_hierarchy and account_range_overlap procs
53: -- .. to test duplicate account overlap
54: --
55:

Line 62: from psb_budget_accounts a,

58: AccSet_ID NUMBER,
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)

Line 94: from psb_budget_accounts b

90: */
91: /*For Bug No : 2255402 End*/
92: and exists
93: (select 1
94: from psb_budget_accounts b
95: where a.code_combination_id = b.code_combination_id
96: and b.account_position_set_id = AccSet_ID);
97:
98:

Line 214: from psb_budget_accounts a,

210: select 'Personnel Services and Non-Personnel Services Account Sets Overlap'
211: from dual
212: where exists
213: (select 1
214: from psb_budget_accounts a,
215: psb_budget_accounts b
216: where a.code_combination_id = b.code_combination_id
217: and a.account_position_set_id = nps_AccSet
218: and b.account_position_set_id = ps_AccSet);

Line 215: psb_budget_accounts b

211: from dual
212: where exists
213: (select 1
214: from psb_budget_accounts a,
215: psb_budget_accounts b
216: where a.code_combination_id = b.code_combination_id
217: and a.account_position_set_id = nps_AccSet
218: and b.account_position_set_id = ps_AccSet);
219:

Line 477: from psb_budget_accounts a,

473: cursor c_Overlap (AccSet_ID NUMBER,
474: Start_Date DATE,
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

Line 478: psb_budget_accounts b,

474: Start_Date DATE,
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

Line 3617: from PSB_BUDGET_ACCOUNTS b,

3613: and gcc.summary_flag = 'N'
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

Line 3727: FROM psb_budget_accounts a,

3723: l_error_count NUMBER := 0;
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'

Line 3735: (SELECT z.code_combination_id from psb_budget_accounts z

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
3734: AND NOT EXISTS
3735: (SELECT z.code_combination_id from psb_budget_accounts z
3736: WHERE z.account_position_set_id in (p_ps_account_set_id, p_nps_account_set_id)
3737: AND a.code_combination_id = z.code_combination_id);
3738:
3739: BEGIN