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.GHR_VALIDATE_PERWSDPO dependencies on GHR_PA_ROUTING_HISTORY

Line 474: ,ghr_pa_routing_history prh

470: ', Employee_Name:'||per.full_name||
471: ', SSN:'||per.national_identifier||
472: ', Updater:'||prh.user_name list_info
473: FROM per_people_f per
474: ,ghr_pa_routing_history prh
475: ,ghr_pa_requests par
476: WHERE par.to_position_id = p_position_id
477: AND par.effective_date >= p_effective_date
478: AND prh.pa_request_id = par.pa_request_id

Line 480: FROM ghr_pa_routing_history prh2

476: WHERE par.to_position_id = p_position_id
477: AND par.effective_date >= p_effective_date
478: AND prh.pa_request_id = par.pa_request_id
479: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)
480: FROM ghr_pa_routing_history prh2
481: WHERE prh2.pa_request_id = par.pa_request_id)
482: AND prh.action_taken IN ('FUTURE_ACTION')
483: AND par.person_id = per.person_id
484: AND par.effective_date between per.effective_start_date and per.effective_end_date