APPS.SSP_SAP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 91: per_periods_of_service SERVICE

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

Line 100: from per_periods_of_service serv

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

Line 481: from per_periods_of_service

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