eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_SET_RELATIONS

Line 1239: from PSB_SET_RELATIONS_V b,

1235: and parameter_set_id = g_parameter_set_id
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

Line 1265: from PSB_SET_RELATIONS_V b,

1261: where p_local_parameter = 'Y'
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

Line 3187: from PSB_SET_RELATIONS_V

3183:
3184: cursor c_account_sets is
3185: select account_position_set_id, account_or_position_type, budget_group_id,
3186: effective_start_date, effective_end_date
3187: from PSB_SET_RELATIONS_V
3188: where budget_group_id in
3189: (select budget_group_id
3190: from psb_budget_groups
3191: where effective_start_date <= l_effective_start_date

Line 4483: from PSB_SET_RELATIONS a,

4479:
4480: cursor c_Budget_Group (CCID NUMBER) is
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

Line 5925: PSB_SET_RELATIONS c,

5921: a.segment25, a.segment26, a.segment27, a.segment28,
5922: a.segment29, a.segment30, a.effective_start_date, a.effective_end_date
5923: from PSB_PAY_ELEMENT_DISTRIBUTIONS a,
5924: PSB_ELEMENT_POS_SET_GROUPS b,
5925: PSB_SET_RELATIONS c,
5926: PSB_BUDGET_POSITIONS d
5927: where a.chart_of_accounts_id = g_flex_code
5928: and (((a.effective_start_date <= p_revision_end_date)
5929: and (a.effective_end_date is null))

Line 6241: PSB_SET_RELATIONS c,

6237: select a.code_combination_id,
6238: a.distribution_percent, a.effective_start_date, a.effective_end_date
6239: from PSB_PAY_ELEMENT_DISTRIBUTIONS a,
6240: PSB_ELEMENT_POS_SET_GROUPS b,
6241: PSB_SET_RELATIONS c,
6242: PSB_BUDGET_POSITIONS d
6243: where a.chart_of_accounts_id = g_flex_code
6244: and (((a.effective_start_date <= p_revision_end_date)
6245: and (a.effective_end_date is null))

Line 7390: psb_set_relations_v e

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'
7394: and e.constraint_id = p_constraint_id);

Line 7435: psb_set_relations_v e

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'
7439: and e.constraint_id = p_constraint_id)

Line 7473: psb_set_relations_v e

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'
7477: and e.constraint_id = p_constraint_id)

Line 8028: PSB_SET_RELATIONS_V b

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,
8032: PSB_SET_RELATIONS_V d

Line 8032: PSB_SET_RELATIONS_V d

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'
8036: and exists

Line 8327: PSB_SET_RELATIONS e

8323: PSB_POSITION_ASSIGNMENTS c
8324: where exists
8325: (select 1
8326: from PSB_BUDGET_POSITIONS d,
8327: PSB_SET_RELATIONS e
8328: where d.data_extract_id = g_data_extract_id
8329: and d.position_id = c.position_id
8330: and d.account_position_set_id = e.account_position_set_id
8331: and e.constraint_id = p_constraint_id)

Line 8356: PSB_SET_RELATIONS f

8352: (select 1
8353: from PSB_BUDGET_REVISION_POSITIONS c,
8354: PSB_BUDGET_REVISION_POS_LINES d,
8355: PSB_BUDGET_POSITIONS e,
8356: PSB_SET_RELATIONS f
8357: where d.budget_revision_id = a.budget_revision_id
8358: and c.budget_revision_pos_line_id = d.budget_revision_pos_line_id
8359: and d.budget_revision_id = p_budget_revision_id
8360: and c.position_id = e.position_id

Line 8377: PSB_SET_RELATIONS g

8373: (select 1
8374: from PSB_BUDGET_REVISION_POSITIONS d,
8375: PSB_BUDGET_REVISION_POS_LINES e,
8376: PSB_BUDGET_POSITIONS f,
8377: PSB_SET_RELATIONS g
8378: where e.budget_revision_id = a.budget_revision_id
8379: and d.budget_revision_pos_line_id = e.budget_revision_pos_line_id
8380: and e.budget_revision_id = p_budget_revision_id
8381: and d.position_id = f.position_id

Line 8837: PSB_SET_RELATIONS f

8833: (select 1
8834: from PSB_BUDGET_REVISION_POSITIONS c,
8835: PSB_BUDGET_REVISION_POS_LINES d,
8836: PSB_BUDGET_POSITIONS e,
8837: PSB_SET_RELATIONS f
8838: where c.budget_revision_pos_line_id = d.budget_revision_pos_line_id
8839: and d.budget_revision_id = p_budget_revision_id
8840: and c.position_id = e.position_id
8841: and e.data_extract_id = g_data_extract_id

Line 9017: PSB_SET_RELATIONS e

9013: from PSB_BUDGET_REVISION_POSITIONS a,
9014: PSB_BUDGET_REVISION_POS_LINES b,
9015: PSB_POSITIONS c,
9016: PSB_BUDGET_POSITIONS d,
9017: PSB_SET_RELATIONS e
9018: where a.budget_revision_pos_line_id = b.budget_revision_pos_line_id
9019: and b.budget_revision_id = p_budget_revision_id
9020: and a.position_id = c.position_id
9021: and c.position_id = d.position_id

Line 10800: PSB_SET_RELATIONS_V sr

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
10804: AND sr.account_or_position_type = 'A'

Line 11161: FROM PSB_BUDGET_ACCOUNTS ba, PSB_SET_RELATIONS_V sr

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 */

Line 11267: ' FROM PSB_BUDGET_ACCOUNTS ba, PSB_SET_RELATIONS_V sr'||

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 '||