APPS.SSP_SMP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 215: per_periods_of_service SERVICE

211: nvl (service.final_process_date, hr_general.end_of_time)
212: FINAL_PROCESS_DATE
213: from ssp_maternities MATERNITY,
214: per_all_people_f PERSON,
215: per_periods_of_service SERVICE
216: where person.person_id = maternity.person_id
217: and person.person_id = service.person_id
218: and maternity.maternity_id = p_maternity_id
219: --

Line 229: from per_periods_of_service serv

225: and nvl(service.actual_termination_date+1,service.date_start)
226: between person.effective_start_date
227: and person.effective_end_date
228: and service.date_start = (select max(serv.date_start)
229: from per_periods_of_service serv
230: where serv.person_id = person.person_id);
231: --
232: --------------------------------------------------------------------------------
233: woman csr_personal_details%rowtype;

Line 663: from per_periods_of_service

659: -- Check the period of service length up to the QW start date
660: --
661: -- 5210118 starts
662: select 1
663: from per_periods_of_service
664: where person_id = woman.person_id
665: and ssp_smp_pkg.continuous_employment_date(woman.due_date) >=
666: (select max(date_start)
667: from per_periods_of_service

Line 667: from per_periods_of_service

663: from per_periods_of_service
664: where person_id = woman.person_id
665: and ssp_smp_pkg.continuous_employment_date(woman.due_date) >=
666: (select max(date_start)
667: from per_periods_of_service
668: where person_id = woman.person_id
669: );
670: -- 5210118 ends
671: --and nvl (actual_termination_date, hr_general.end_of_time) -- BUG 3436510

Line 709: from per_periods_of_service ser

705: --
706: cursor csr_period_of_service_qw is
707: select nvl(ser.actual_termination_date, hr_general.end_of_time) termination_date
708: ,leaving_reason leaving_reason
709: from per_periods_of_service ser
710: where ser.person_id = woman.person_id
711: and ssp_smp_pkg.continuous_employment_date(woman.due_date)
712: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
713: --

Line 715: l_termination_date per_periods_of_service.actual_termination_date%type;

711: and ssp_smp_pkg.continuous_employment_date(woman.due_date)
712: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
713: --
714: l_proc varchar2(72) := g_package||'check_employment_qw';
715: l_termination_date per_periods_of_service.actual_termination_date%type;
716: l_leaving_reason hr_lookups.meaning%type;
717: --
718: -- Local Function
719: function get_leaving_reason(p_leaving_reason in varchar2)