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.PAY_GB_HR_HELPDESK dependencies on PER_PERIODS_OF_SERVICE

Line 332: from per_periods_of_service pps

328: ,to_char(pps.actual_termination_date,'YYYY-MM-DD') actual_termination_date
329: ,to_char(pps.final_process_date,'YYYY-MM-DD') final_process_date
330: ,to_char(pps.last_standard_process_date,'YYYY-MM-DD') last_standard_process_date
331: ,leaving_reason
332: from per_periods_of_service pps
333: where pps.person_id = p_person_id
334: and ( ( p_employee_number is null )
335: or ( p_employee_number is not null
336: and pps.date_start = (

Line 338: from per_periods_of_service pps1

334: and ( ( p_employee_number is null )
335: or ( p_employee_number is not null
336: and pps.date_start = (
337: select max(pps1.date_start)
338: from per_periods_of_service pps1
339: where pps1.person_id = p_person_id
340: and pps1.date_start <= to_date(p_effective_end_date,'YYYY-MM-DD') ) ) );
341: cursor csr_periods_of_placement(p_person_id number, p_employee_number number, p_effective_end_date varchar2) is
342: select null adjusted_svc_date