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_PA_REQUEST_EXTRA_INFO

Line 181: FROM ghr_pa_request_extra_info rei

177: ,p_noa_id IN NUMBER)
178: RETURN VARCHAR2 IS
179: CURSOR c_rei IS
180: SELECT rei.rei_information3 agency_code
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

Line 209: FROM ghr_pa_request_extra_info rei

205: ,p_noa_id IN NUMBER)
206: RETURN VARCHAR2 IS
207: CURSOR c_rei IS
208: SELECT rei.rei_information3 agency_code
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

Line 855: from ghr_pa_request_extra_info

851: nvl(REI_INFORMATION6,0) +
852: nvl(REI_INFORMATION7,0) +
853: nvl(REI_INFORMATION8,0)) cal_amt,
854: nvl(REI_INFORMATION11,0) tot_amt
855: from ghr_pa_request_extra_info
856: where pa_request_id = p_pa_request_id
857: and information_type = 'GHR_US_PAR_MD_DDS_PAY';
858:
859: BEGIN