APPS.PSB_WORKSHEET_PVT dependencies on PSB_WORKSHEETS

Line 1008: PSB_WORKSHEETS_V b

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: */
1012:

Line 1020: FROM psb_worksheets

1016: SELECT nvl(global_worksheet_id, worksheet_id) global_worksheet_id,
1017: data_extract_id
1018: INTO l_global_worksheet_id,
1019: l_data_extract_id
1020: FROM psb_worksheets
1021: WHERE worksheet_id = p_worksheet_id;
1022:
1023: -- Do not need to query if it's a global worksheet
1024: IF p_worksheet_id <> l_global_worksheet_id THEN

Line 1026: FROM psb_worksheets

1022:
1023: -- Do not need to query if it's a global worksheet
1024: IF p_worksheet_id <> l_global_worksheet_id THEN
1025: SELECT data_extract_id INTO l_data_extract_id
1026: FROM psb_worksheets
1027: WHERE worksheet_id = l_global_worksheet_id ;
1028: END IF;
1029: /* Bug 3458191 end */
1030:

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