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

Line 968: from ghr_remarks rem,

964: ,l_pa_request_id
965: ,rem.remark_id
966: ,rem.description
967: ,1
968: from ghr_remarks rem,
969: ghr_noac_remarks nre
970: where nre.nature_of_action_id = p_first_noa_id
971: and nre.required_flag = 'Y'
972: and l_effective_date

Line 995: from ghr_remarks rem,

991: ,l_pa_request_id
992: ,rem.remark_id
993: ,rem.description
994: ,1
995: from ghr_remarks rem,
996: ghr_noac_remarks nre
997: where nre.nature_of_action_id = p_second_noa_id
998: and nre.required_flag = 'Y'
999: and l_effective_date

Line 3012: from ghr_remarks rem

3008: ,p_pa_request_id
3009: ,rem.remark_id
3010: ,rem.description
3011: ,1
3012: from ghr_remarks rem
3013: ,ghr_noac_remarks nre
3014: where nre.nature_of_action_id = p_first_noa_id
3015: and nre.required_flag = 'Y'
3016: and l_effective_date

Line 3050: from ghr_remarks rem

3046: ,p_pa_request_id
3047: ,rem.remark_id
3048: ,rem.description
3049: ,1
3050: from ghr_remarks rem
3051: ,ghr_noac_remarks nre
3052: where nre.nature_of_action_id = p_second_noa_id
3053: and nre.required_flag = 'Y'
3054: and l_effective_date