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_PA_REMARKS

Line 156: FROM ghr_pa_remarks gpr

152: SELECT gpr.remark_id
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

Line 3134: from ghr_pa_remarks

3130: ) return varchar2 is
3131:
3132: /*cursor csr_rem_dsc(c_pa_remark_id in number) is
3133: select description
3134: from ghr_pa_remarks
3135: where pa_remark_id = c_pa_remark_id;*/
3136:
3137:
3138: CURSOR csr_rem_dsc(c_pa_remark_id number

Line 3144: FROM ghr_pa_remarks gpr

3140: ,c_effective_date date) is
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