APPS.HRHIRAPL dependencies on PER_PERIODS_OF_SERVICE

Line 167: from per_periods_of_service pps

163: if p_emp_apl ='Y' then
164: begin
165: select pps.period_of_service_id
166: into v_dummy
167: from per_periods_of_service pps
168: where p_start_date between pps.date_start
169: and nvl(pps.ACTUAL_TERMINATION_DATE,p_end_of_time)
170: and pps.person_id = p_person_id
171: and pps.business_group_id + 0 = p_business_group_id;

Line 185: select per_periods_of_service_s.nextval

181: end;
182: else
183: hr_utility.set_location('hr_person.get_period_of_service',2);
184: begin
185: select per_periods_of_service_s.nextval
186: into v_dummy
187: from sys.dual;
188: exception
189: when no_data_found then

Line 199: insert into per_periods_of_service

195: end;
196: --
197: hr_utility.set_location('hr_person.get_period_of_service',3);
198: begin
199: insert into per_periods_of_service
200: (period_of_service_id
201: ,business_group_id
202: ,person_id
203: ,date_start

Line 4281: from per_periods_of_service pps

4277:
4278: --
4279: cursor check_past_pds is
4280: select 1
4281: from per_periods_of_service pps
4282: where pps.person_id =p_person_id
4283: and date_start <= (select effective_date
4284: from fnd_sessions
4285: where session_id =

Line 4289: from per_periods_of_service pps

4285: where session_id =
4286: userenv('sessionid'));
4287: cursor check_pds is
4288: select 1
4289: from per_periods_of_service pps
4290: where pps.person_id =p_person_id;
4291:
4292: begin
4293: hr_utility.set_location('Entering : hr_person.ins_per_list',5);