APPS.HRHIRAPL dependencies on PER_PERIODS_OF_SERVICE

Line 187: from per_periods_of_service pps

183: if p_emp_apl ='Y' then
184: begin
185: select pps.period_of_service_id
186: into v_dummy
187: from per_periods_of_service pps
188: where p_start_date between pps.date_start
189: and nvl(pps.ACTUAL_TERMINATION_DATE,p_end_of_time)
190: and pps.person_id = p_person_id
191: and pps.business_group_id + 0 = p_business_group_id;

Line 205: select per_periods_of_service_s.nextval

201: end;
202: else
203: hr_utility.set_location('hr_person.get_period_of_service',2);
204: begin
205: select per_periods_of_service_s.nextval
206: into v_dummy
207: from sys.dual;
208: exception
209: when no_data_found then

Line 219: insert into per_periods_of_service

215: end;
216: --
217: hr_utility.set_location('hr_person.get_period_of_service',3);
218: begin
219: insert into per_periods_of_service
220: (period_of_service_id
221: ,business_group_id
222: ,person_id
223: ,date_start

Line 4886: from per_periods_of_service pps

4882:
4883: --
4884: cursor check_past_pds is
4885: select 1
4886: from per_periods_of_service pps
4887: where pps.person_id =p_person_id
4888: and date_start <= (select effective_date
4889: from fnd_sessions
4890: where session_id =

Line 4894: from per_periods_of_service pps

4890: where session_id =
4891: userenv('sessionid'));
4892: cursor check_pds is
4893: select 1
4894: from per_periods_of_service pps
4895: where pps.person_id =p_person_id;
4896:
4897: begin
4898: hr_utility.set_location('Entering : hr_person.ins_per_list',5);