[Home] [Help]
1816:
1817:
1818: Cursor l_dup_asg_cur is
1819: Select assignment_id
1820: from psb_employees_i
1821: where hr_position_id = l_hr_position_id
1822: and hr_employee_id = l_hr_employee_id
1823: and data_extract_id = p_data_extract_id;
1824:
1944:
1945: For l_dup_asg_rec in l_dup_asg_cur
1946: Loop
1947: if (employee_rec.primary_flag = 'Y') then
1948: delete psb_employees_i
1949: where hr_position_id = l_hr_position_id
1950: and hr_employee_id = l_hr_employee_id
1951: and data_extract_id = p_data_extract_id;
1952: else
2075: --Stop extracting secured data of employee
2076: --Removed the columns in psb_employees table
2077: /*For Bug No : 2594575 End*/
2078:
2079: INSERT INTO PSB_EMPLOYEES_I
2080: (HR_EMPLOYEE_ID ,
2081: HR_POSITION_ID ,
2082: ASSIGNMENT_ID ,
2083: GRADE_ID ,
2378: Cursor C_Assign_Check is
2379: Select assignment_id,
2380: first_name,
2381: last_name
2382: from PSB_EMPLOYEES_I
2383: where hr_position_id = le_position_id
2384: and assignment_id = le_assignment_id
2385: and data_extract_id = p_data_extract_id;
2386:
4413: b.effective_start_date,
4414: b.effective_end_date,
4415: a.effective_start_date date_effective,
4416: a.effective_end_date date_end
4417: from fnd_sessions d, per_all_assignments_f b, hr_all_positions_f a , psb_positions_i c, psb_employees_i e
4418: where d.session_id = userenv('sessionid')
4419: and d.effective_date between a.effective_start_date and a.effective_end_date
4420: and d.effective_date between b.effective_start_date and b.effective_end_date
4421: and a.business_group_id = p_business_group_id
4648: /*For Bug No : 2109120 End*/
4649:
4650: Cursor C_Emp_Name is
4651: Select first_name,last_name
4652: from psb_employees_i
4653: where hr_employee_id = l_person_id
4654: and data_extract_id = p_data_extract_id;
4655:
4656: Cursor C_Hiredate is