APPS.PSB_WS_POS3 dependencies on PSB_BUDGET_GROUPS_V

Line 266: from PSB_BUDGET_GROUPS_V

262:
263: cursor c_BG is
264: select nvl(business_group_id, root_business_group_id) business_group_id,
265: nvl(currency_code, root_currency_code) currency_code
266: from PSB_BUDGET_GROUPS_V
267: where budget_group_id = l_budget_group_id;
268:
269: cursor c_Parameter (Year_Start_Date DATE,
270: Year_End_Date DATE) is

Line 562: PSB_BUDGET_GROUPS_V b

558: nvl(b.currency_code, b.root_currency_code) currency_code,
559: nvl(b.root_budget_group_id, b.budget_group_id) root_budget_group_id,
560: nvl(b.set_of_books_id, b.root_set_of_books_id) set_of_books_id
561: from PSB_WORKSHEETS_V a,
562: PSB_BUDGET_GROUPS_V b
563: where a.worksheet_id = p_worksheet_id
564: and b.budget_group_id = a.budget_group_id;
565:
566: cursor c_Parameter is

Line 1528: PSB_BUDGET_GROUPS_V b

1524: a.budget_calendar_id,
1525: nvl(b.business_group_id, b.root_business_group_id) business_group_id,
1526: nvl(b.currency_code, b.root_currency_code) currency_code
1527: from PSB_WORKSHEETS_V a,
1528: PSB_BUDGET_GROUPS_V b
1529: where a.worksheet_id = p_worksheet_id
1530: and b.budget_group_id = a.budget_group_id;
1531:
1532: cursor c_Parameter is

Line 1808: from PSB_BUDGET_GROUPS_V

1804:
1805: cursor c_BG is
1806: select nvl(business_group_id, root_business_group_id) business_group_id,
1807: nvl(currency_code, root_currency_code) currency_code
1808: from PSB_BUDGET_GROUPS_V
1809: where budget_group_id = l_budget_group_id;
1810:
1811: cursor c_Parameter (Year_Start_Date DATE,
1812: Year_End_Date DATE) is

Line 2149: PSB_BUDGET_GROUPS_V b

2145: cursor c_BG is
2146: select nvl(b.root_budget_group_id, b.budget_group_id) root_budget_group_id,
2147: nvl(b.set_of_books_id, b.root_set_of_books_id) set_of_books_id
2148: from PSB_WORKSHEETS_V a,
2149: PSB_BUDGET_GROUPS_V b
2150: where a.worksheet_id = p_worksheet_id
2151: and b.budget_group_id = a.budget_group_id;
2152:
2153: cursor c_SOB is

Line 3765: from PSB_BUDGET_GROUPS_V

3761: cursor c_BG is
3762: select nvl(business_group_id, root_business_group_id) business_group_id,
3763: nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id,
3764: nvl(currency_code, root_currency_code) currency_code
3765: from PSB_BUDGET_GROUPS_V
3766: where budget_group_id = l_budget_group_id;
3767:
3768: cursor c_Positions is
3769: select a.position_id,