DBA Data[Home] [Help]

APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_WORKSHEETS

Line 2335: PSB_WORKSHEETS b

2331: cursor c_Global_WS is
2332: select b.data_extract_id,
2333: a.business_group_id
2334: from PSB_DATA_EXTRACTS a,
2335: PSB_WORKSHEETS b
2336: where a.data_extract_id = b.data_extract_id
2337: and b.worksheet_id = p_global_worksheet_id;
2338:
2339: cursor c_Local_WS_Pos is

Line 2344: PSB_WORKSHEETS b,

2340: select c.local_worksheet_id,
2341: b.data_extract_id,
2342: a.business_group_id
2343: from PSB_DATA_EXTRACTS a,
2344: PSB_WORKSHEETS b,
2345: PSB_WS_CONSOLIDATION_DETAILS c
2346: where a.data_extract_id = b.data_extract_id
2347: and b.worksheet_id = c.local_worksheet_id
2348: and c.global_worksheet_id = p_global_worksheet_id;

Line 2602: PSB_WORKSHEETS b

2598: b.budget_by_position,
2599: b.budget_group_id,
2600: nvl(a.set_of_books_id, a.root_set_of_books_id) set_of_books_id
2601: from PSB_BUDGET_GROUPS_V a,
2602: PSB_WORKSHEETS b
2603: where a.budget_group_id = b.budget_group_id
2604: and b.worksheet_id = p_global_worksheet_id;
2605:
2606: cursor c_Local_WS is

Line 2616: PSB_WORKSHEETS b,

2612: b.budget_by_position,
2613: b.budget_group_id,
2614: nvl(a.set_of_books_id, a.root_set_of_books_id) set_of_books_id
2615: from PSB_BUDGET_GROUPS_V a,
2616: PSB_WORKSHEETS b,
2617: PSB_WS_CONSOLIDATION_DETAILS c
2618: where a.budget_group_id = b.budget_group_id
2619: and b.worksheet_id = c.local_worksheet_id
2620: and c.global_worksheet_id = p_global_worksheet_id;