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_CHECK dependencies on GHR_PA_ROUTING_HISTORY

Line 244: FROM ghr_pa_routing_history prh

240:
241: -- Sundar 3263109 To find out if any future actions exist.
242: CURSOR c_future_actions(c_person_id ghr_pa_requests.person_id%type, c_effective_date ghr_pa_requests.effective_date%type) IS
243: SELECT par.pa_request_id futr_rpa
244: FROM ghr_pa_routing_history prh
245: ,ghr_pa_requests par
246: WHERE prh.pa_request_id = par.pa_request_id
247: AND par.person_id = c_person_id
248: AND par.effective_date > c_effective_date

Line 250: FROM ghr_pa_routing_history prh2

246: WHERE prh.pa_request_id = par.pa_request_id
247: AND par.person_id = c_person_id
248: AND par.effective_date > c_effective_date
249: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)
250: FROM ghr_pa_routing_history prh2
251: WHERE prh2.pa_request_id = par.pa_request_id)
252: AND prh.action_taken IN ('FUTURE_ACTION','UPDATE_HR_COMPLETE')
253: AND par.NOA_FAMILY_CODE <> 'CANCEL'
254: AND ( ( par.second_noa_code IS NULL