DBA Data[Home] [Help]

APPS.PSB_WS_ACCT2 dependencies on PSB_BUDGET_GROUPS_V

Line 2636: FROM psb_budget_groups_v

2632: SELECT NVL(set_of_books_id, root_set_of_books_id) set_of_books_id,
2633: NVL(currency_code, root_currency_code) currency_code,
2634: NVL(chart_of_accounts_id, root_chart_of_accounts_id) flex_code,
2635: ps_account_position_set_id
2636: FROM psb_budget_groups_v
2637: WHERE budget_group_id = l_budget_group_id
2638: )
2639: LOOP
2640: l_set_of_books_id := l_bg_rec.set_of_books_id;

Line 4079: PSB_BUDGET_GROUPS_V b

4075: a.stage_set_id,
4076: a.current_stage_seq
4077: /* bug no 4256345 */
4078: from PSB_WORKSHEETS_V a,
4079: PSB_BUDGET_GROUPS_V b
4080: where a.worksheet_id = p_worksheet_id
4081: and b.budget_group_id = a.budget_group_id;
4082:
4083: cursor c_Parameter is

Line 4430: from PSB_BUDGET_GROUPS_V

4426:
4427: cursor c_SOB is
4428: select nvl(currency_code, root_currency_code) currency_code,
4429: nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id
4430: from PSB_BUDGET_GROUPS_V
4431: where budget_group_id = p_budget_group_id;
4432:
4433: -- Find all Parameters that are applicable for this CCID for the Budget Year
4434: -- identified by Year_Start_Date, Year_End_Date. The CCID should be valid for

Line 8068: from PSB_BUDGET_GROUPS_V

8064:
8065: cursor c_BG is
8066: select nvl(set_of_books_id, root_set_of_books_id) set_of_books_id,
8067: nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id
8068: from PSB_BUDGET_GROUPS_V
8069: where budget_group_id = l_budget_group_id;
8070:
8071: BEGIN
8072: