APPS.GHR_VALIDATE_PERWSEPI dependencies on GHR_PA_ROUTING_HISTORY

Line 49: FROM ghr_pa_routing_history prh

45: ', 1st NOA Code:'||par.first_noa_code||
46: DECODE(par.second_noa_code,NULL,NULL, ', 2nd NOA Code:'||par.second_noa_code)||
47: ', Effective Date:'||par.effective_date||
48: ', Updater:'||prh.user_name list_info
49: FROM ghr_pa_routing_history prh
50: ,ghr_pa_requests par
51: WHERE par.person_id = p_person_id
52: AND par.effective_date BETWEEN NVL(p_from_date,par.effective_date) AND NVL(p_to_date,par.effective_date)
53: AND prh.pa_request_id = par.pa_request_id

Line 55: FROM ghr_pa_routing_history prh2

51: WHERE par.person_id = p_person_id
52: AND par.effective_date BETWEEN NVL(p_from_date,par.effective_date) AND NVL(p_to_date,par.effective_date)
53: AND prh.pa_request_id = par.pa_request_id
54: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)
55: FROM ghr_pa_routing_history prh2
56: WHERE prh2.pa_request_id = par.pa_request_id)
57: AND prh.action_taken IN ('FUTURE_ACTION')
58: ORDER BY par.effective_date, par.pa_request_id;
59: