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 138: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS

134: WHERE
135: PA_REQUEST_ID = c_pa_request_id
136: AND GHR_PA_REQUESTS.NOA_FAMILY_CODE = FAM.NOA_FAMILY_CODE;
137:
138: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS
139: SELECT
140: pre.description,
141: pre.pa_request_id,
142: remk.code remark_code

Line 144: ghr_pa_remarks pre,

140: pre.description,
141: pre.pa_request_id,
142: remk.code remark_code
143: FROM
144: ghr_pa_remarks pre,
145: ghr_remarks remk
146: WHERE remk.remark_id = pre.remark_id
147: AND pre.pa_request_id = c_pa_request_id;
148:

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

1496: FROM GHR_PA_REQUESTS PAR
1497: WHERE PA_REQUEST_ID = c_pa_request_id;
1498:
1499:
1500: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS
1501: SELECT
1502: pre.description,
1503: pre.pa_request_id,
1504: remk.code remark_code

Line 1506: ghr_pa_remarks pre,

1502: pre.description,
1503: pre.pa_request_id,
1504: remk.code remark_code
1505: FROM
1506: ghr_pa_remarks pre,
1507: ghr_remarks remk
1508: WHERE remk.remark_id = pre.remark_id
1509: AND pre.pa_request_id = c_pa_request_id;
1510: