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_REMARKS_API dependencies on GHR_NOAC_REMARKS

Line 37: ghr_noac_remarks nre

33: Cursor C_Sel1 is
34: Select pre.pa_remark_id,
35: pre.object_version_number
36: from ghr_pa_remarks pre,
37: ghr_noac_remarks nre
38: where pre.pa_request_id = p_pa_request_id and
39: pre.remark_id = p_remark_id and
40: nre.remark_id = pre.remark_id and
41: (nre.nature_of_action_id =

Line 342: from ghr_noac_remarks nre,

338: l_exists boolean := false;
339: --
340: Cursor C_remark_reqd1 is
341: select 1
342: from ghr_noac_remarks nre,
343: ghr_pa_remarks pre,
344: ghr_pa_requests par
345: where pre.pa_remark_id = p_pa_remark_id
346: and par.pa_request_id = pre.pa_request_id

Line 361: from ghr_noac_remarks nre,

357:
358:
359: Cursor C_remark_reqd2 is
360: select 1
361: from ghr_noac_remarks nre,
362: ghr_pa_remarks pre,
363: ghr_pa_requests par
364: where pre.pa_remark_id = p_pa_remark_id
365: and par.pa_request_id = pre.pa_request_id