APPS.PSB_WS_POS3 dependencies on PSB_WORKSHEETS_V

Line 260: from PSB_WORKSHEETS_V

256: budget_group_id,
257: nvl(data_extract_id, global_data_extract_id) data_extract_id,
258: budget_calendar_id,
259: nvl(parameter_set_id, global_parameter_set_id) parameter_set_id
260: from PSB_WORKSHEETS_V
261: where worksheet_id = p_worksheet_id;
262:
263: cursor c_BG is
264: select nvl(business_group_id, root_business_group_id) business_group_id,

Line 561: from PSB_WORKSHEETS_V a,

557: nvl(b.business_group_id, b.root_business_group_id) business_group_id,
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:

Line 1527: from PSB_WORKSHEETS_V a,

1523: nvl(a.data_extract_id, a.global_data_extract_id) data_extract_id,
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:

Line 1802: from PSB_WORKSHEETS_V

1798: budget_group_id,
1799: nvl(data_extract_id, global_data_extract_id) data_extract_id,
1800: budget_calendar_id,
1801: nvl(parameter_set_id, global_parameter_set_id) parameter_set_id
1802: from PSB_WORKSHEETS_V
1803: where worksheet_id = p_worksheet_id;
1804:
1805: cursor c_BG is
1806: select nvl(business_group_id, root_business_group_id) business_group_id,

Line 2148: from PSB_WORKSHEETS_V a,

2144:
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:

Line 3758: from PSB_WORKSHEETS_V

3754: rounding_factor,
3755: nvl(data_extract_id, global_data_extract_id) data_extract_id,
3756: budget_group_id,
3757: current_stage_seq
3758: from PSB_WORKSHEETS_V
3759: where worksheet_id = p_worksheet_id;
3760:
3761: cursor c_BG is
3762: select nvl(business_group_id, root_business_group_id) business_group_id,