APPS.PSB_WS_ACCT1 dependencies on PSB_BUDGET_GROUPS

Line 438: from PSB_BUDGET_GROUPS

434: select root_budget_group_id,
435: root_budget_group,
436: ps_account_position_set_id psid,
437: nps_account_position_set_id npsid
438: from PSB_BUDGET_GROUPS
439: where budget_group_id = p_budget_group_id;
440:
441: cursor c_CCID2 (BudgetGroupID NUMBER) is
442: select ps_account_position_set_id psid,

Line 444: from PSB_BUDGET_GROUPS

440:
441: cursor c_CCID2 (BudgetGroupID NUMBER) is
442: select ps_account_position_set_id psid,
443: nps_account_position_set_id npsid
444: from PSB_BUDGET_GROUPS
445: where budget_group_id = BudgetGroupID;
446: */
447: /* Bug 3543845 end */
448:

Line 487: FROM PSB_BUDGET_GROUPS

483: l_root_budget_group_id,
484: l_root_budget_group,
485: l_ps_acct_pos_set_id,
486: l_nps_acct_pos_set_id
487: FROM PSB_BUDGET_GROUPS
488: WHERE budget_group_id = p_budget_group_id;
489:
490: IF l_root_budget_group is NULL OR l_root_budget_group = 'N'
491: THEN

Line 497: FROM PSB_BUDGET_GROUPS

493: nps_account_position_set_id
494: INTO
495: l_ps_acct_pos_set_id,
496: l_nps_acct_pos_set_id
497: FROM PSB_BUDGET_GROUPS
498: WHERE budget_group_id = l_root_budget_group_id;
499: END IF;
500:
501:

Line 2618: from PSB_WORKSHEETS_V a, PSB_BUDGET_GROUPS b

2614: a.flex_mapping_set_id,
2615: a.gl_cutoff_period,
2616: nvl(b.root_budget_group_id, b.budget_group_id) root_budget_group_id,
2617: local_copy_flag
2618: from PSB_WORKSHEETS_V a, PSB_BUDGET_GROUPS b
2619: where a.worksheet_id = p_worksheet_id
2620: and b.budget_group_id = a.budget_group_id;
2621: --
2622: cursor c_CCID is

Line 2638: PSB_BUDGET_GROUPS b,

2634: cursor c_Budget_Group is
2635: select a.budget_group_id,
2636: b.num_proposed_years
2637: from PSB_SET_RELATIONS a,
2638: PSB_BUDGET_GROUPS b,
2639: PSB_BUDGET_ACCOUNTS c
2640: where a.budget_group_id = b.budget_group_id
2641: and (((b.effective_start_date <= l_end_date)
2642: and (b.effective_end_date is null))

Line 5791: FROM psb_budget_groups

5787:
5788: CURSOR l_Budget_Group_csr (c_budgetgroup_id NUMBER)
5789: IS
5790: SELECT budget_group_id
5791: FROM psb_budget_groups
5792: WHERE budget_group_type = 'R'
5793: START WITH budget_group_id = c_budgetgroup_id
5794: CONNECT BY prior budget_group_id = parent_budget_group_id;
5795:

Line 6857: from psb_budget_groups e

6853: and c.code_combination_id = a.code_combination_id
6854: and d.account_or_position_type = 'A'
6855: and exists
6856: (select 1
6857: from psb_budget_groups e
6858: where e.budget_group_type = 'R'
6859: and e.effective_start_date <= g_startdate_pp
6860: and (e.effective_end_date is null or e.effective_end_date >= g_enddate_cy)
6861: and e.budget_group_id = d.budget_group_id