[Home] [Help]
2729:
2730: -- This statment will pull the position_line_ids from worksheet table
2731: -- those are existing in the worksheet to be uploaded.
2732: SELECT psb_pos_lines.position_line_id INTO l_pos_line_id
2733: FROM psb_ws_position_lines psb_pos_lines,
2734: psb_ws_lines_positions psb_lines_pos
2735: WHERE psb_pos_lines.position_line_id = psb_lines_pos.position_line_id
2736: AND psb_pos_lines.position_id = p_source_DE_position_id
2737: AND psb_lines_pos.worksheet_id = p_worksheet_id;
3084: pos.attribute11, pos.attribute12, pos.attribute13, pos.attribute14, pos.attribute15,
3085: pos.attribute16, pos.attribute17, pos.attribute18, pos.attribute19, pos.attribute20,
3086: pos.attribute_category, pos.name, wpl.budget_group_id
3087: from PSB_POSITIONS pos,
3088: PSB_WS_POSITION_LINES wpl,
3089: PSB_WS_LINES_POSITIONS wlp
3090: where data_extract_id = p_source_data_extract_id
3091: and wpl.position_id = pos.position_id
3092: and wlp.worksheet_id = p_worksheet_id
4130:
4131: cursor c_wpl is
4132: /*For Bug No : 1808322 Start*/
4133: --The following sql statement has been commented because of
4134: --FTS on PSB_WS_POSITION_LINES table.
4135: --The same was achived by the next query
4136:
4137: /*select *
4138: from PSB_WS_POSITION_LINES a
4134: --FTS on PSB_WS_POSITION_LINES table.
4135: --The same was achived by the next query
4136:
4137: /*select *
4138: from PSB_WS_POSITION_LINES a
4139: where exists
4140: (select 1
4141: from PSB_WS_LINES_POSITIONS b
4142: where b.position_line_id = a.position_line_id
4143: and b.worksheet_id = p_worksheet_id);*/
4144:
4145: -- for bug 4545590
4146: select a.position_id, a.position_line_id
4147: from PSB_WS_POSITION_LINES a,
4148: PSB_WS_LINES_POSITIONS b
4149: where a.position_line_id = b.position_line_id
4150: and b.worksheet_id = p_worksheet_id;
4151: /*For Bug No : 1808322 End*/
5396: select 'Exists'
5397: from dual
5398: where exists
5399: (select 'Exists'
5400: from psb_ws_position_lines wpl, psb_ws_lines_positions wlp
5401: where wpl.position_id = p_position_id
5402: and wlp.position_line_id = wpl.position_line_id
5403: and wlp.worksheet_id = p_source_id);
5404:
5452: select 'Exists'
5453: from dual
5454: where exists
5455: (select 'Exists'
5456: from psb_ws_position_lines wpl, psb_ws_lines_positions wlp, psb_ws_account_lines wal
5457: where wpl.position_id = p_position_id
5458: and wlp.position_line_id = wpl.position_line_id
5459: and wlp.worksheet_id = p_source_id
5460: and wal.position_line_id = wpl.position_line_id);
8175: select 'Exists'
8176: from dual
8177: where exists
8178: (select 'Exists'
8179: from psb_ws_lines_positions wlp, psb_ws_position_lines wpl, psb_position_assignments ppa
8180: where wlp.worksheet_id = p_source_id
8181: and wpl.position_line_id = wlp.position_line_id
8182: and ppa.position_id = wpl.position_id
8183: and ppa.pay_element_id = l_element_id
9424: from psb_positions pp, psb_position_costs ppc
9425: where pp.data_extract_id = p_system_data_extract_id
9426: and exists
9427: (select 'Exists'
9428: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp
9429: where pp1.data_extract_id = p_data_extract_id
9430: and pp1.hr_position_id = pp.hr_position_id
9431: and wpl.position_id = pp1.position_id
9432: and wlp.position_line_id = wpl.position_line_id
9454: from psb_positions pp, psb_position_fte ppf
9455: where pp.data_extract_id = p_system_data_extract_id
9456: and exists
9457: (select 'Exists'
9458: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp
9459: where pp1.data_extract_id = p_data_extract_id
9460: and pp1.hr_position_id = pp.hr_position_id
9461: and wpl.position_id = pp1.position_id
9462: and wlp.position_line_id = wpl.position_line_id
9483: -- associated with the data extract.
9484: CURSOR l_position_csr
9485: IS
9486: SELECT position_id
9487: FROM psb_ws_position_lines a, psb_ws_lines_positions b
9488: WHERE worksheet_id = p_source_id
9489: AND a.position_line_id = b.position_line_id;
9490: /* bug no 3670254 */
9491: