[Home] [Help]
1236: and parameter_id = p_parameter_id
1237: and exists
1238: (select 1
1239: from PSB_SET_RELATIONS_V b,
1240: PSB_BUDGET_ACCOUNTS c
1241: where b.account_or_position_type = 'A'
1242: and b.account_position_set_id = c.account_position_set_id
1243: and b.parameter_id = p_parameter_id
1244: and c.code_combination_id = p_ccid)
1262: and entity_id = p_parameter_id
1263: and exists
1264: (select 1
1265: from PSB_SET_RELATIONS_V b,
1266: PSB_BUDGET_ACCOUNTS c
1267: where b.account_or_position_type = 'A'
1268: and b.account_position_set_id = c.account_position_set_id
1269: and b.parameter_id = p_parameter_id
1270: and c.code_combination_id = p_ccid)
4481: select a.budget_group_id,
4482: b.num_proposed_years
4483: from PSB_SET_RELATIONS a,
4484: PSB_BUDGET_GROUPS b,
4485: PSB_BUDGET_ACCOUNTS c
4486: where a.budget_group_id = b.budget_group_id
4487: and b.effective_start_date <= p_start_date
4488: and (b.effective_end_date is null
4489: or b.effective_end_date >= p_end_date)
7385: and a.currency_code = p_currency_code
7386: and a.position_id is null
7387: and exists
7388: (select 1
7389: from psb_budget_accounts d,
7390: psb_set_relations_v e
7391: where d.account_position_set_id = e.account_position_set_id
7392: and d.code_combination_id = a.code_combination_id
7393: and e.account_or_position_type = 'A'
7430: psb_budget_revision_lines pbrl,
7431: psb_budget_revisions pbr
7432: where pbra.code_combination_id in
7433: (select d.code_combination_id
7434: from psb_budget_accounts d,
7435: psb_set_relations_v e
7436: where d.account_position_set_id = e.account_position_set_id
7437: and d.code_combination_id = pbra.code_combination_id
7438: and e.account_or_position_type = 'A'
7468: FROM psb_budget_revision_accounts pbra,
7469: psb_budget_revision_lines pbrl
7470: WHERE pbra.code_combination_id in
7471: (select d.code_combination_id
7472: from psb_budget_accounts d,
7473: psb_set_relations_v e
7474: where d.account_position_set_id = e.account_position_set_id
7475: and d.code_combination_id = pbra.code_combination_id
7476: and e.account_or_position_type = 'A'
8023: -- CCIDs assigned to the Constraint : select CCIDs that also belong to the Budget Group Hierarchy
8024:
8025: cursor c_CCID is
8026: select a.code_combination_id ccid
8027: from PSB_BUDGET_ACCOUNTS a,
8028: PSB_SET_RELATIONS_V b
8029: where exists
8030: (select 1
8031: from PSB_BUDGET_ACCOUNTS c,
8027: from PSB_BUDGET_ACCOUNTS a,
8028: PSB_SET_RELATIONS_V b
8029: where exists
8030: (select 1
8031: from PSB_BUDGET_ACCOUNTS c,
8032: PSB_SET_RELATIONS_V d
8033: where c.account_position_set_id = d.account_position_set_id
8034: and c.code_combination_id = a.code_combination_id
8035: and d.account_or_position_type = 'A'
10795: /*For Bug No : 2161125 Start*/
10796: AND bra.position_id IS NULL
10797: /*For Bug No : 2161125 End*/
10798: AND EXISTS (SELECT 1
10799: FROM PSB_BUDGET_ACCOUNTS ba,
10800: PSB_SET_RELATIONS_V sr
10801: WHERE ba.code_combination_id = bra.code_combination_id
10802: AND ba.account_position_set_id = sr.account_position_set_id
10803: AND sr.rule_id = l_rule_id
11157: /*For Bug No : 2150471 End*/
11158:
11159: cursor c_CCID is
11160: SELECT ba.code_combination_id, sr.apply_balance_flag
11161: FROM PSB_BUDGET_ACCOUNTS ba, PSB_SET_RELATIONS_V sr
11162: WHERE ba.account_position_set_id = sr.account_position_set_id
11163: AND sr.account_or_position_type = 'A'
11164: AND sr.rule_id = p_rule_id
11165: /* Bug No 2135165 Start */
11263: ' WHERE glcc.code_combination_id = rcc.code_combination_id';
11264:
11265: -- Bug 5030405 used bind variables in the following string
11266: l_acct_sql_temp := 'SELECT ba.code_combination_id, sr.apply_balance_flag '||
11267: ' FROM PSB_BUDGET_ACCOUNTS ba, PSB_SET_RELATIONS_V sr'||
11268: ' WHERE ba.account_position_set_id = sr.account_position_set_id'||
11269: ' AND sr.account_or_position_type = '||''''||'A'||''''||
11270: ' AND sr.rule_id = :b_rule_id'||
11271: ' AND ba.code_combination_id in (SELECT bra.code_combination_id '||