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.

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_BUDGET_GROUPS

Line 56: from PSB_BUDGET_GROUPS

52: from PSB_BUDGET_REVISIONS
53: where nvl(global_budget_revision_id, budget_revision_id) = GlobalRevID
54: and budget_group_id in
55: (select budget_group_id
56: from PSB_BUDGET_GROUPS
57: where budget_group_type = 'R'
58: start with budget_group_id = BudgetGroupID
59: connect by prior parent_budget_group_id = budget_group_id);
60:

Line 704: from PSB_BUDGET_GROUPS_V

700: select nvl(root_budget_group_id, budget_group_id) root_budget_group_id,
701: nvl(set_of_books_id, root_set_of_books_id) set_of_books_id,
702: nvl(business_group_id, root_business_group_id) business_group_id,
703: name
704: from PSB_BUDGET_GROUPS_V
705: where budget_group_id = g_budget_group_id;
706:
707: cursor c_Sob is
708: select currency_code,

Line 744: (select budget_group_id from PSB_BUDGET_GROUPS

740: from dual
741: where exists
742: (select a.position_id, a.effective_start_date, a.effective_end_date, a.budget_group_id
743: from PSB_POSITIONS a,
744: (select budget_group_id from PSB_BUDGET_GROUPS
745: start with budget_group_id = g_budget_group_id
746: connect by prior budget_group_id = parent_budget_group_id) b
747: where a.data_extract_id = g_data_extract_id
748: and a.budget_group_id = b.budget_group_id);

Line 1568: from PSB_WORKSHEETS a, PSB_BUDGET_GROUPS b

1564: l_currency_code VARCHAR2(15);
1565:
1566: cursor c_bg is
1567: select nvl(b.root_budget_group_id, b.budget_group_id) budget_group_id
1568: from PSB_WORKSHEETS a, PSB_BUDGET_GROUPS b
1569: where a.worksheet_id = p_worksheet_id
1570: and b.budget_group_id = a.budget_group_id;
1571:
1572: -- Bug 3029168 added the join with currency code

Line 1882: from psb_budget_groups_v

1878: and period_name in (p_gl_period, p_end_gl_period);
1879:
1880: Cursor c_Root_Budget_Group is
1881: Select nvl(root_budget_group_id,budget_group_id) root_budget_group_id
1882: from psb_budget_groups_v
1883: where budget_group_id = p_budget_group_id;
1884:
1885: Begin
1886:

Line 2521: psb_budget_groups pbg

2517:
2518: Cursor C_system_data_extract is
2519: Select data_extract_id
2520: from psb_data_extracts pde,
2521: psb_budget_groups pbg
2522: where system_data_extract = 'Y'
2523: and (((pde.budget_group_id = pbg.root_budget_group_id)
2524: and (pbg.budget_group_id = p_budget_group_id))
2525: or ((pde.budget_group_id = pbg.budget_group_id)

Line 3190: from psb_budget_groups

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
3192: and (effective_end_date is null or
3193: effective_end_date >= l_effective_end_date)
3194: start with budget_group_id = g_budget_group_id

Line 3201: (select budget_group_id from PSB_BUDGET_GROUPS

3197:
3198: cursor c_positions is
3199: select a.position_id, a.effective_start_date, a.effective_end_date, a.budget_group_id
3200: from PSB_POSITIONS a,
3201: (select budget_group_id from PSB_BUDGET_GROUPS
3202: start with budget_group_id = g_budget_group_id
3203: connect by prior budget_group_id = parent_budget_group_id) b
3204: where a.data_extract_id = p_data_extract_id
3205: and a.budget_group_id = b.budget_group_id

Line 4484: PSB_BUDGET_GROUPS b,

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
4488: and (b.effective_end_date is null

Line 8038: from psb_budget_groups e

8034: and c.code_combination_id = a.code_combination_id
8035: and d.account_or_position_type = 'A'
8036: and exists
8037: (select 1
8038: from psb_budget_groups e
8039: where e.budget_group_type = 'R'
8040: and e.budget_group_id = d.budget_group_id
8041: start with e.budget_group_id = g_budget_group_id
8042: connect by prior e.budget_group_id = e.parent_budget_group_id))

Line 10858: FROM PSB_BUDGET_GROUPS

10854: SELECT rrs.rule_set_id
10855: FROM PSB_REVISION_RULE_SETS_V rrs
10856: WHERE rrs.enable_flag = 'Y'
10857: and rrs.budget_group_id in (select budget_group_id
10858: FROM PSB_BUDGET_GROUPS
10859: WHERE budget_group_type = 'R'
10860: START WITH budget_group_id = l_budget_group_id
10861: CONNECT BY PRIOR parent_budget_group_id = budget_group_id));
10862:

Line 10880: WHERE set_of_books_id = (SELECT b.set_of_books_id FROM PSB_BUDGET_GROUPS a,

10876: /* Bug No 2135165 Start */
10877: g_brr_sob_id
10878: /* Bug No 2135165 End */
10879: FROM gl_sets_of_books
10880: WHERE set_of_books_id = (SELECT b.set_of_books_id FROM PSB_BUDGET_GROUPS a,
10881: PSB_BUDGET_GROUPS b
10882: WHERE a.budget_group_id = l_budget_group_id
10883: and nvl(a.root_budget_group_id, a.budget_group_id) = b.budget_group_id);
10884: --

Line 10881: PSB_BUDGET_GROUPS b

10877: g_brr_sob_id
10878: /* Bug No 2135165 End */
10879: FROM gl_sets_of_books
10880: WHERE set_of_books_id = (SELECT b.set_of_books_id FROM PSB_BUDGET_GROUPS a,
10881: PSB_BUDGET_GROUPS b
10882: WHERE a.budget_group_id = l_budget_group_id
10883: and nvl(a.root_budget_group_id, a.budget_group_id) = b.budget_group_id);
10884: --
10885: /*For Bug No : 2125969 Start*/