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_GEN_RPA_NPA dependencies on GHR_PA_REMARKS

Line 188: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS

184: WHERE
185: PA_REQUEST_ID = c_pa_request_id
186: AND GHR_PA_REQUESTS.NOA_FAMILY_CODE = FAM.NOA_FAMILY_CODE;
187:
188: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS
189: SELECT
190: pre.description,
191: pre.pa_request_id,
192: remk.code remark_code

Line 194: ghr_pa_remarks pre,

190: pre.description,
191: pre.pa_request_id,
192: remk.code remark_code
193: FROM
194: ghr_pa_remarks pre,
195: ghr_remarks remk
196: WHERE remk.remark_id = pre.remark_id
197: AND pre.pa_request_id = c_pa_request_id;
198:

Line 1733: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS

1729: FROM GHR_PA_REQUESTS PAR
1730: WHERE PA_REQUEST_ID = c_pa_request_id;
1731:
1732:
1733: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS
1734: SELECT
1735: pre.description,
1736: pre.pa_request_id,
1737: remk.code remark_code

Line 1739: ghr_pa_remarks pre,

1735: pre.description,
1736: pre.pa_request_id,
1737: remk.code remark_code
1738: FROM
1739: ghr_pa_remarks pre,
1740: ghr_remarks remk
1741: WHERE remk.remark_id = pre.remark_id
1742: AND pre.pa_request_id = c_pa_request_id;
1743: