APPS.PSB_WORKSHEET dependencies on PSB_BUDGET_GROUPS

Line 297: from PSB_BUDGET_GROUPS

293:
294: cursor c_bg1 is
295: select Count(*) count_bg1,
296: Max(last_update_date) lud_bg1
297: from PSB_BUDGET_GROUPS
298: where budget_group_type = 'R'
299: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
300: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
301: start with budget_group_id = p_budget_group_id

Line 310: from PSB_BUDGET_GROUPS

306: Max(last_update_date) lud_bg2
307: from PSB_SET_RELATIONS
308: where budget_group_id in
309: (select budget_group_id
310: from PSB_BUDGET_GROUPS
311: where budget_group_type = 'R'
312: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
313: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
314: start with budget_group_id = p_budget_group_id

Line 1090: from PSB_BUDGET_GROUPS_V

1086: cursor c_BG is
1087: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id,
1088: nvl(currency_code, root_currency_code) currency_code,
1089: nvl(business_group_id, root_business_group_id) business_group_id
1090: from PSB_BUDGET_GROUPS_V
1091: where budget_group_id = l_budget_group_id;
1092:
1093: cursor c_ConstSet is
1094: select name,

Line 1975: from PSB_BUDGET_GROUPS_V

1971: cursor c_BG is
1972: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id,
1973: nvl(currency_code, root_currency_code) currency_code,
1974: nvl(business_group_id, root_business_group_id) business_group_id
1975: from PSB_BUDGET_GROUPS_V
1976: where budget_group_id = l_budget_group_id;
1977:
1978: cursor c_ConstSet is
1979: select name,

Line 2188: from PSB_BUDGET_GROUPS_V

2184: cursor c_BG is
2185: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id,
2186: nvl(currency_code, root_currency_code) currency_code,
2187: nvl(business_group_id, root_business_group_id) business_group_id
2188: from PSB_BUDGET_GROUPS_V
2189: where budget_group_id = l_budget_group_id;
2190:
2191: cursor c_ConstSet is
2192: select name,

Line 2402: from PSB_BUDGET_GROUPS_V

2398: cursor c_BG is
2399: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id,
2400: nvl(currency_code, root_currency_code) currency_code,
2401: nvl(business_group_id, root_business_group_id) business_group_id
2402: from PSB_BUDGET_GROUPS_V
2403: where budget_group_id = l_budget_group_id;
2404:
2405: cursor c_ConstSet is
2406: select name,

Line 2821: from psb_budget_groups

2817: from dual;
2818:
2819: cursor c_Budget_Group is
2820: select short_name
2821: from psb_budget_groups
2822: where budget_group_id = p_budget_group_id;
2823:
2824: BEGIN
2825:

Line 3588: PSB_BUDGET_GROUPS_PVT.Check_Budget_Group_Freeze

3584: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3585: raise FND_API.G_EXC_ERROR;
3586: end if;
3587:
3588: PSB_BUDGET_GROUPS_PVT.Check_Budget_Group_Freeze
3589: (p_api_version => 1.0,
3590: p_budget_group_id => g_budget_group_id,
3591: p_return_status => l_return_status,
3592: p_msg_count => l_msg_count,

Line 3691: from PSB_BUDGET_GROUPS_V

3687: nvl(name, root_name) name,
3688: root_budget_group,
3689: ps_account_position_set_id psapsid,
3690: nps_account_position_set_id npsapsid
3691: from PSB_BUDGET_GROUPS_V
3692: where budget_group_id = g_budget_group_id;
3693:
3694: cursor c_Sob is
3695: select currency_code,

Line 3907: FROM PSB_BUDGET_GROUPS

3903: nps_account_position_set_id
3904: INTO
3905: g_ps_acct_pos_set_id,
3906: g_nps_acct_pos_set_id
3907: FROM PSB_BUDGET_GROUPS
3908: WHERE budget_group_id = g_root_budget_group_id;
3909:
3910: END IF;
3911: /* Bug 3543845 End */