APPS.GHR_PA_REQUESTS_PKG2 dependencies on GHR_PA_ROUTING_HISTORY

Line 29: ,ghr_pa_routing_history prh

25: ', Effective Date:'||fnd_date.date_to_chardate(par.effective_date)||
26: DECODE(prh.action_taken,'FUTURE_ACTION', ', APPROVED',
27: ', Routed To '||DECODE(gbx.name,null, 'User:'||prh.user_name, 'Groupbox:'||gbx.name)) list_info
28: FROM ghr_groupboxes gbx
29: ,ghr_pa_routing_history prh
30: ,ghr_pa_requests par
31: WHERE gbx.groupbox_id(+) = prh.groupbox_id
32: AND par.person_id = p_person_id
33: AND par.pa_request_id <> NVL(p_pa_request_id,-999)

Line 36: FROM ghr_pa_routing_history prh2

32: AND par.person_id = p_person_id
33: AND par.pa_request_id <> NVL(p_pa_request_id,-999)
34: AND prh.pa_request_id = par.pa_request_id
35: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)
36: FROM ghr_pa_routing_history prh2
37: WHERE prh2.pa_request_id = par.pa_request_id)
38: AND NVL(prh.action_taken,'==@@==') NOT IN ('CANCELED','UPDATE_HR_COMPLETE')
39: AND (prh.date_notification_sent is not null
40: OR prh.action_taken = 'FUTURE_ACTION')

Line 75: FROM ghr_pa_routing_history prh

71: DECODE(par.second_noa_code,NULL,NULL, ', 2nd NOA Code:'||par.second_noa_code)||
72: DECODE(par.second_noa_cancel_or_correct,'CANCEL','(CANCELED)')||
73: --- ', Effective Date:'||TO_CHAR(par.effective_date,'DD-MON-YYYY') list_info
74: ', Effective Date:'||fnd_date.date_to_chardate(par.effective_date) list_info
75: FROM ghr_pa_routing_history prh
76: ,ghr_pa_requests par
77: WHERE par.person_id = p_person_id
78: AND par.effective_date >= p_effective_date
79: AND prh.pa_request_id = par.pa_request_id

Line 81: FROM ghr_pa_routing_history prh2

77: WHERE par.person_id = p_person_id
78: AND par.effective_date >= p_effective_date
79: AND prh.pa_request_id = par.pa_request_id
80: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)
81: FROM ghr_pa_routing_history prh2
82: WHERE prh2.pa_request_id = par.pa_request_id)
83: AND prh.action_taken IN ('FUTURE_ACTION','UPDATE_HR_COMPLETE')
84: AND par.NOA_FAMILY_CODE <> 'CANCEL'
85: AND ( ( par.second_noa_code IS NULL