eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WS_POS3 dependencies on PSB_WORKSHEET

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,

Line 4497: PSB_WORKSHEET.Delete_WAL

4493:
4494: if PSB_WS_POS1.g_element_dist(l_eldist_index).redist_flag is null then
4495: begin
4496:
4497: PSB_WORKSHEET.Delete_WAL
4498: (p_api_version => 1.0,
4499: p_return_status => l_return_status,
4500: p_account_line_id => PSB_WS_POS1.g_element_dist(l_eldist_index).account_line_id);
4501:

Line 5293: PSB_WORKSHEETS b

5289:
5290: cursor c_SumAll is
5291: select sum(nvl(a.element_cost, 0)) Sum_Elem
5292: from PSB_WS_ELEMENT_LINES a,
5293: PSB_WORKSHEETS b
5294: where exists
5295: (select 1
5296: from PSB_WS_LINES_POSITIONS c,
5297: PSB_WS_POSITION_LINES d,

Line 5317: PSB_WORKSHEETS b,

5313:
5314: cursor c_SumAll_Salary is
5315: select sum(nvl(a.element_cost, 0)) Sum_Elem
5316: from PSB_WS_ELEMENT_LINES a,
5317: PSB_WORKSHEETS b,
5318: PSB_PAY_ELEMENTS c
5319: where exists
5320: (select 1
5321: from PSB_WS_LINES_POSITIONS d,

Line 5346: PSB_WORKSHEETS b

5342:
5343: cursor c_SumAllSP is
5344: select sum(nvl(a.element_cost, 0)) Sum_Elem
5345: from PSB_WS_ELEMENT_LINES a,
5346: PSB_WORKSHEETS b
5347: where exists
5348: (select 1
5349: from PSB_WS_LINES_POSITIONS c,
5350: PSB_WS_POSITION_LINES d,

Line 5375: PSB_WORKSHEETS b,

5371:
5372: cursor c_SumAllSP_Salary is
5373: select sum(nvl(a.element_cost, 0)) Sum_Elem
5374: from PSB_WS_ELEMENT_LINES a,
5375: PSB_WORKSHEETS b,
5376: PSB_PAY_ELEMENTS c
5377: where exists
5378: (select 1
5379: from PSB_WS_LINES_POSITIONS d,

Line 5407: select /+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) /

5403: and c.business_group_id = p_business_group_id
5404: and c.data_extract_id = p_data_extract_id;
5405:
5406: cursor c_Sum is
5407: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5408: sum(nvl(a.element_cost, 0)) Sum_Elem
5409: from PSB_WS_ELEMENT_LINES a,
5410: PSB_WORKSHEETS b
5411: where a.currency_code = p_currency_code

Line 5410: PSB_WORKSHEETS b

5406: cursor c_Sum is
5407: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5408: sum(nvl(a.element_cost, 0)) Sum_Elem
5409: from PSB_WS_ELEMENT_LINES a,
5410: PSB_WORKSHEETS b
5411: where a.currency_code = p_currency_code
5412: and a.stage_set_id = b.stage_set_id
5413: and a.pay_element_id = p_pay_element_id
5414: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq

Line 5423: PSB_WORKSHEETS b,

5419: cursor c_Sum_Salary is
5420: select /*+ ORDERED INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5421: sum(nvl(a.element_cost, 0)) Sum_Elem
5422: from PSB_WS_ELEMENT_LINES a,
5423: PSB_WORKSHEETS b,
5424: PSB_PAY_ELEMENTS c
5425: where a.currency_code = p_currency_code
5426: and a.stage_set_id = b.stage_set_id
5427: and a.pay_element_id = c.pay_element_id

Line 5438: select /+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) /

5434: and c.business_group_id = p_business_group_id
5435: and c.data_extract_id = p_data_extract_id;
5436:
5437: cursor c_SumSP is
5438: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5439: sum(nvl(a.element_cost, 0)) Sum_Elem
5440: from PSB_WS_ELEMENT_LINES a,
5441: PSB_WORKSHEETS b
5442: where exists

Line 5441: PSB_WORKSHEETS b

5437: cursor c_SumSP is
5438: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5439: sum(nvl(a.element_cost, 0)) Sum_Elem
5440: from PSB_WS_ELEMENT_LINES a,
5441: PSB_WORKSHEETS b
5442: where exists
5443: (select 1
5444: from PSB_WS_SUBMIT_SERVICE_PACKAGES d
5445: where d.service_package_id = a.service_package_id

Line 5459: PSB_WORKSHEETS b,

5455: cursor c_SumSP_Salary is
5456: select /*+ ORDERED INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5457: sum(nvl(a.element_cost, 0)) Sum_Elem
5458: from PSB_WS_ELEMENT_LINES a,
5459: PSB_WORKSHEETS b,
5460: PSB_PAY_ELEMENTS c
5461: where exists
5462: (select 1
5463: from PSB_WS_SUBMIT_SERVICE_PACKAGES d

Line 5885: PSB_WORKSHEETS b

5881:
5882: cursor c_SumAll is
5883: select sum(nvl(a.annual_fte, 0)) Sum_FTE
5884: from PSB_WS_FTE_LINES a,
5885: PSB_WORKSHEETS b
5886: where exists
5887: (select 1
5888: from PSB_WS_LINES_POSITIONS c,
5889: PSB_WS_POSITION_LINES d,

Line 5907: PSB_WORKSHEETS b

5903:
5904: cursor c_SumAllSP is
5905: select sum(nvl(a.annual_fte, 0)) Sum_FTE
5906: from PSB_WS_FTE_LINES a,
5907: PSB_WORKSHEETS b
5908: where exists
5909: (select 1
5910: from PSB_WS_LINES_POSITIONS c,
5911: PSB_WS_POSITION_LINES d,

Line 5932: select /+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) /

5928: and a.budget_year_id = p_budget_year_id
5929: and b.worksheet_id = p_worksheet_id;
5930:
5931: cursor c_Sum is
5932: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5933: sum(nvl(a.annual_fte, 0)) Sum_FTE
5934: from PSB_WS_FTE_LINES a,
5935: PSB_WORKSHEETS b
5936: where b.current_stage_seq between a.start_stage_seq and a.current_stage_seq

Line 5935: PSB_WORKSHEETS b

5931: cursor c_Sum is
5932: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5933: sum(nvl(a.annual_fte, 0)) Sum_FTE
5934: from PSB_WS_FTE_LINES a,
5935: PSB_WORKSHEETS b
5936: where b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5937: and a.stage_set_id = b.stage_set_id
5938: and a.budget_year_id = p_budget_year_id
5939: and a.position_line_id = p_position_line_id

Line 5943: select /+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) /

5939: and a.position_line_id = p_position_line_id
5940: and b.worksheet_id = p_worksheet_id;
5941:
5942: cursor c_SumSP is
5943: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5944: sum(nvl(a.annual_fte, 0)) Sum_FTE
5945: from PSB_WS_FTE_LINES a,
5946: PSB_WORKSHEETS b
5947: where exists

Line 5946: PSB_WORKSHEETS b

5942: cursor c_SumSP is
5943: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5944: sum(nvl(a.annual_fte, 0)) Sum_FTE
5945: from PSB_WS_FTE_LINES a,
5946: PSB_WORKSHEETS b
5947: where exists
5948: (select 1
5949: from PSB_WS_SUBMIT_SERVICE_PACKAGES d
5950: where d.worksheet_id = p_worksheet_id