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_US_NFC_EXTRACTS dependencies on GHR_REMARKS

Line 157: ,ghr_remarks gr

153: ,gpr.pa_request_id
154: ,gpr.pa_remark_id
155: ,code
156: FROM ghr_pa_remarks gpr
157: ,ghr_remarks gr
158: WHERE pa_request_id = c_request_id
159: AND gr.remark_id=gpr.remark_id
160: AND c_effective_date between gr.date_from
161: and NVL(gr.date_to,to_date('12/31/4712','MM/DD/YYYY'))

Line 3145: ,ghr_remarks gr

3141: SELECT gpr.remark_id
3142: ,gpr.description
3143: ,gr.code
3144: FROM ghr_pa_remarks gpr
3145: ,ghr_remarks gr
3146: WHERE gpr.pa_remark_id = c_pa_remark_id
3147: AND pa_request_id = c_request_id
3148: AND gr.remark_id=gpr.remark_id
3149: AND c_effective_date between gr.date_from