APPS.GHR_PA_REQUESTS_PKG2 dependencies on GHR_GROUPBOXES

Line 28: FROM ghr_groupboxes gbx

24: ------ ', Effective Date:'||TO_CHAR(par.effective_date,'DD-MON-YYYY')||
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