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_PA_REQUESTS_PKG2 dependencies on GHR_NOA_FAMILIES

Line 185: FROM ghr_noa_families naf

181: FROM ghr_pa_request_extra_info rei
182: WHERE rei.pa_request_id = p_pa_request_id
183: AND rei.information_type = 'GHR_US_PAR_APPT_TRANSFER'
184: AND EXISTS (SELECT 1
185: FROM ghr_noa_families naf
186: ,ghr_pa_request_info_types rit
187: WHERE rei.information_type = rit.information_type
188: AND rit.noa_family_code = naf.noa_family_code
189: AND naf.nature_of_action_id = p_noa_id);

Line 213: FROM ghr_noa_families naf

209: FROM ghr_pa_request_extra_info rei
210: WHERE rei.pa_request_id = p_pa_request_id
211: AND rei.information_type = 'GHR_US_PAR_MASS_TERM'
212: AND EXISTS (SELECT 1
213: FROM ghr_noa_families naf
214: ,ghr_pa_request_info_types rit
215: WHERE rei.information_type = rit.information_type
216: AND rit.noa_family_code = naf.noa_family_code
217: AND naf.nature_of_action_id = p_noa_id);