APPS.GHR_VALIDATE_PERWSEPI dependencies on GHR_PA_REQUESTS

Line 50: ,ghr_pa_requests par

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
54: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)