APPS.PSB_WS_ACCT2 dependencies on PSB_BUDGET_GROUPS

Line 21: FROM psb_budget_groups

17: CURSOR c_BudGrp (budgetgroup_id NUMBER)
18: IS
19: SELECT budget_group_id,
20: num_proposed_years
21: FROM psb_budget_groups
22: WHERE budget_group_type = 'R'
23: AND effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
24: AND ( effective_end_date is null or effective_end_date >=
25: PSB_WS_ACCT1.g_enddate_cy )

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 7740: from PSB_BUDGET_GROUPS f

7736: and b.template_id is null
7737: and c.set_of_books_id = p_set_of_books_id
7738: and exists
7739: (select 1
7740: from PSB_BUDGET_GROUPS f
7741: where f.budget_group_id = b.budget_group_id
7742: and (f.budget_group_id = p_budget_group_id or f.root_budget_group_id = p_budget_group_id))
7743: and exists
7744: (select 1

Line 7844: 'from psb_budget_groups ' ||

7840: l_bgroups_tbl(l_bgroups_index) := l_bgroup_id;
7841:
7842: sql_sumbgroup := 'select parent_budget_group_id, ' ||
7843: 'root_budget_group ' ||
7844: 'from psb_budget_groups ' ||
7845: 'where budget_group_id = :budget_group_id';
7846:
7847: cur_sumbgroup := dbms_sql.open_cursor;
7848: dbms_sql.parse(cur_sumbgroup, sql_sumbgroup, dbms_sql.v7);

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: