APPS.SSP_ERN_BUS dependencies on PER_PERIODS_OF_SERVICE

Line 64: from per_periods_of_service s

60: l_proc varchar2(72) := g_package||'Check_Effective_Date';
61:
62: cursor c2 is
63: select s.person_id
64: from per_periods_of_service s
65: where s.person_id = p_person_id
66: and p_effective_date between s.date_start and
67: nvl(s.actual_termination_date,hr_general.end_of_time);
68:

Line 189: -- check the no of rows in per_periods_of_service table

185: );
186: --
187: -- (abhaduri)added cursor to check whether employee has been re-hired
188: cursor csr_noof_periods_service is
189: -- check the no of rows in per_periods_of_service table
190: -- to calculate the no of times
191: -- the employee has been employed by the employer
192: select count(*) from per_periods_of_service
193: where person_id = p_person_id;

Line 192: select count(*) from per_periods_of_service

188: cursor csr_noof_periods_service is
189: -- check the no of rows in per_periods_of_service table
190: -- to calculate the no of times
191: -- the employee has been employed by the employer
192: select count(*) from per_periods_of_service
193: where person_id = p_person_id;
194: --
195: -- (abhaduri) added cursor to get the last termination date
196: -- if employer has been employed more than once by the employer

Line 200: from per_periods_of_service

196: -- if employer has been employed more than once by the employer
197: cursor csr_earlier_term is
198: -- get the termination date if it is not null
199: select nvl(max(actual_termination_date),to_date('01/01/01','DD/MM/YY'))
200: from per_periods_of_service
201: where person_id = p_person_id
202: and actual_termination_date is not null;
203: --
204:

Line 495: from per_periods_of_service SERVICE

491: -- Get the period of service current as of a specified date
492: --
493: select service.period_of_service_id,
494: service.date_start
495: from per_periods_of_service SERVICE
496: where person_id = p_person_id
497: and p_effective_date between service.date_start
498: and nvl (service.actual_termination_date,
499: hr_general.end_of_time);