APPS.SSP_SAP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 89: per_periods_of_service SERVICE

85: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
86: from
87: ssp_maternities MATERNITY,
88: per_all_people_f PERSON,
89: per_periods_of_service SERVICE
90: where
91: person.person_id = maternity.person_id
92: and person.person_id = service.person_id
93: and maternity.maternity_id = p_maternity_id

Line 98: from per_periods_of_service serv

94: and nvl(service.actual_termination_date+1,service.date_start)
95: between person.effective_start_date
96: and person.effective_end_date
97: and service.date_start = (select max(serv.date_start)
98: from per_periods_of_service serv
99: where serv.person_id = person.person_id);
100: --
101: --------------------------------------------------------------------------------
102: person csr_personal_details%rowtype;

Line 479: from per_periods_of_service

475: --
476: -- Check the period of service length up to the MW start date
477: --
478: select 1
479: from per_periods_of_service
480: where person_id = person.person_id
481: and date_start <= ssp_sap_pkg.continuous_employment_date
482: (person.matching_date)
483: and nvl (actual_termination_date, hr_general.end_of_time)