eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SSP_SSP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 283: per_periods_of_service SERVICE

279: nvl (service.last_standard_process_date,
280: hr_general.end_of_time) LAST_STANDARD_PROCESS_DATE,
281: service.leaving_reason
282: from per_all_people_f PERSON,
283: per_periods_of_service SERVICE
284: where person.person_id = p_person_id
285: and service.person_id = person.person_id
286: and p_date_start between service.date_start
287: and nvl (service.actual_termination_date,

Line 4043: -- PER_PERIODS_OF_SERVICE.

4039: procedure SSP1L_control (
4040: --
4041: -- If prior employment details are updated then we must recalculate SSP
4042: -- This procedure is called from the after update row-level trigger on
4043: -- PER_PERIODS_OF_SERVICE.
4044: --
4045: p_person_id in number,
4046: p_date_start in date
4047: ) is