APPS.PSB_WORKSHEET_PVT dependencies on PSB_BUDGET_GROUPS

Line 1007: from PSB_BUDGET_GROUPS_V a,

1003:
1004: cursor c_BG is
1005: select nvl(b.data_extract_id, b.global_data_extract_id) data_extract_id,
1006: nvl(a.root_budget_group_id, a.budget_group_id) root_budget_group_id
1007: from PSB_BUDGET_GROUPS_V a,
1008: PSB_WORKSHEETS_V b
1009: where a.budget_group_id = b.budget_group_id
1010: and b.worksheet_id = p_worksheet_id;
1011: */

Line 1053: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy

1049: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1050: raise FND_API.G_EXC_ERROR;
1051: end if;
1052:
1053: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy
1054: (p_api_version => 1.0,
1055: p_init_msg_list => FND_API.G_TRUE,
1056: p_return_status => l_return_status,
1057: p_msg_count => l_msg_count,

Line 1199: FROM psb_budget_groups bg

1195: SELECT bg.budget_group_id,
1196: bg.set_of_books_id
1197: INTO l_root_budget_group_id,
1198: l_set_of_books_id
1199: FROM psb_budget_groups bg
1200: WHERE bg.budget_group_id =
1201: (SELECT nvl(bg1.root_budget_group_id, bg1.budget_group_id) root_budget_group_id
1202: FROM psb_worksheets ws, psb_budget_groups bg1
1203: WHERE bg1.budget_group_id = ws.budget_group_id

Line 1202: FROM psb_worksheets ws, psb_budget_groups bg1

1198: l_set_of_books_id
1199: FROM psb_budget_groups bg
1200: WHERE bg.budget_group_id =
1201: (SELECT nvl(bg1.root_budget_group_id, bg1.budget_group_id) root_budget_group_id
1202: FROM psb_worksheets ws, psb_budget_groups bg1
1203: WHERE bg1.budget_group_id = ws.budget_group_id
1204: and ws.worksheet_id = p_worksheet_id);
1205:
1206: PSB_Budget_Account_PVT.Populate_Budget_Accounts

Line 1223: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy

1219: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1220: raise FND_API.G_EXC_ERROR;
1221: end if;
1222:
1223: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy
1224: (
1225: p_api_version => 1.0,
1226: p_init_msg_list => FND_API.G_TRUE,
1227: p_return_status => l_return_status,