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 543: ,ghr_pa_routing_history prh

539: ', Employee_Name:'||per.full_name||
540: ', SSN:'||per.national_identifier||
541: ', Updater:'||prh.user_name list_info
542: FROM per_people_f per
543: ,ghr_pa_routing_history prh
544: ,ghr_pa_requests par
545: WHERE par.to_position_id = p_position_id
546: AND par.effective_date >= p_effective_date
547: AND prh.pa_request_id = par.pa_request_id

Line 549: FROM ghr_pa_routing_history prh2

545: WHERE par.to_position_id = p_position_id
546: AND par.effective_date >= p_effective_date
547: AND prh.pa_request_id = par.pa_request_id
548: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)
549: FROM ghr_pa_routing_history prh2
550: WHERE prh2.pa_request_id = par.pa_request_id)
551: AND prh.action_taken IN ('FUTURE_ACTION')
552: AND par.person_id = per.person_id
553: AND par.effective_date between per.effective_start_date and per.effective_end_date