APPS.PER_DB_PER_ADDITIONAL dependencies on PER_PERIODS_OF_SERVICE

Line 139: SELECT per_periods_of_service_s.nextval

135: begin
136: --
137: --
138: hr_utility.set_location('per_db_per_additional.insert_period_of_service',1);
139: SELECT per_periods_of_service_s.nextval
140: INTO l_period_of_service_id
141: FROM sys.dual;
142: --
143: hr_utility.set_location('per_db_per_additional.insert_period_of_service',2);

Line 157: INSERT INTO per_periods_of_service

153: WHERE pp.person_id = p_person_id
154: AND pp.current_employee_flag = 'Y');
155: --
156: hr_utility.set_location('per_db_per_additional.insert_period_of_service',5);
157: INSERT INTO per_periods_of_service
158: (period_of_service_id
159: ,business_group_id
160: ,person_id
161: ,date_start

Line 569: FROM per_periods_of_service

565: hr_utility.set_location('per_db_per_additional.insert_assignment',20);
566: if p_assignment_type = 'E' then -- Employee
567: SELECT period_of_service_id
568: INTO l_period_of_service_id
569: FROM per_periods_of_service
570: WHERE person_id = p_person_id
571: AND p_effective_start_date
572: BETWEEN date_start AND
573: nvl(actual_termination_date,to_date('4712/12/31','YYYY/MM/DD'))

Line 2223: FROM per_periods_of_service pos

2219: --
2220: hr_utility.set_location('per_db_per_additional.create_contact',2);
2221: SELECT pp.person_id
2222: INTO l_person_id
2223: FROM per_periods_of_service pos
2224: , per_people_f pp
2225: WHERE pp.business_group_id + 0 = l_business_group_id
2226: AND pp.current_employee_flag = 'Y'
2227: AND pp.employee_number = p_employee_number