[Home] [Help]
4233: PP.hr_employee_id,
4234: PP.effective_start_DATE,
4235: PP.effective_END_DATE
4236: FROM PSB_POSITIONS PP,
4237: PSB_POSITIONS_I PPI
4238: WHERE PP.data_extract_id = p_data_extract_id
4239: AND PP.data_extract_id = PPI.data_extract_id
4240: AND PP.position_id > p_restart_position_id
4241: AND PP.hr_position_id = PPI.hr_position_id
5696:
5697: /* Bug 3417868 Start */
5698:
5699: CURSOR l_position_source IS
5700: SELECT * FROM psb_positions_i
5701: WHERE data_extract_id = p_data_extract_id
5702: AND hr_position_id > l_restart_hr_position_id
5703: ORDER BY hr_position_id,
5704: hr_employee_id;
5762: TYPE l_position_i_tbl_type IS TABLE OF l_position_i_rec_type
5763: INDEX BY BINARY_INTEGER;
5764:
5765: --bug#4166493, rec type modified to add additional columns necessary to update
5766: --psb positions in refresh mode.
5767:
5768: TYPE l_position_rec_type IS RECORD
5769: ( hr_position_id NUMBER,
5770: hr_employee_id NUMBER,
6799: END IF;
6800:
6801: l_last_hr_position_id:= l_pos_record.hr_position_id;
6802:
6803: END LOOP; -- END processing all the positions FROM psb_positions_i table.
6804: CLOSE l_position_source;
6805: /* Bug 3417868 End */
6806:
6807: /* For Bug No: 3066598 Start */
6932: l_api_name CONSTANT VARCHAR2(30) := 'Populate_Employee';
6933: l_api_version CONSTANT NUMBER := 1.0;
6934:
6935: -- Outer join IS NOT needed FOR ( pe.hr_employee_id = pp.hr_employee_id)
6936: -- because psb_positions IS populated with proper hr_employee_id prior to
6937: -- running thIS process.
6938: /*For Bug No : 2594575 Start*/
6939: --Stop extracting secured data of employee
6940: --Removed the columns in psb_employees table