APPS.SSP_SMP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 222: per_periods_of_service SERVICE

218: nvl (service.final_process_date, hr_general.end_of_time)
219: FINAL_PROCESS_DATE
220: from ssp_maternities MATERNITY,
221: per_all_people_f PERSON,
222: per_periods_of_service SERVICE
223: where person.person_id = maternity.person_id
224: and person.person_id = service.person_id
225: and maternity.maternity_id = p_maternity_id
226: --

Line 236: from per_periods_of_service serv

232: and nvl(service.actual_termination_date+1,service.date_start)
233: between person.effective_start_date
234: and person.effective_end_date
235: and service.date_start = (select max(serv.date_start)
236: from per_periods_of_service serv
237: where serv.person_id = person.person_id);
238: --
239: --------------------------------------------------------------------------------
240: woman csr_personal_details%rowtype;

Line 670: from per_periods_of_service

666: -- Check the period of service length up to the QW start date
667: --
668: -- 5210118 starts
669: select 1
670: from per_periods_of_service
671: where person_id = woman.person_id
672: and ssp_smp_pkg.continuous_employment_date(woman.due_date) >=
673: (select max(date_start)
674: from per_periods_of_service

Line 674: from per_periods_of_service

670: from per_periods_of_service
671: where person_id = woman.person_id
672: and ssp_smp_pkg.continuous_employment_date(woman.due_date) >=
673: (select max(date_start)
674: from per_periods_of_service
675: where person_id = woman.person_id
676: );
677: -- 5210118 ends
678: --and nvl (actual_termination_date, hr_general.end_of_time) -- BUG 3436510

Line 716: from per_periods_of_service ser

712: --
713: cursor csr_period_of_service_qw is
714: select nvl(ser.actual_termination_date, hr_general.end_of_time) termination_date
715: ,leaving_reason leaving_reason
716: from per_periods_of_service ser
717: where ser.person_id = woman.person_id
718: and ssp_smp_pkg.continuous_employment_date(woman.due_date)
719: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
720: --

Line 722: l_termination_date per_periods_of_service.actual_termination_date%type;

718: and ssp_smp_pkg.continuous_employment_date(woman.due_date)
719: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
720: --
721: l_proc varchar2(72) := g_package||'check_employment_qw';
722: l_termination_date per_periods_of_service.actual_termination_date%type;
723: l_leaving_reason hr_lookups.meaning%type;
724: --
725: -- Local Function
726: function get_leaving_reason(p_leaving_reason in varchar2)