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_GHRWS52L dependencies on GHR_NOA_FAMILIES

Line 307: select noa_family_code from ghr_noa_families

303: where pa_request_id=p_pa_request_id and first_noa_code='002';
304:
305:
306: Cursor fam_code(p_second_noa_id number) is
307: select noa_family_code from ghr_noa_families
308: where nature_of_action_id=p_second_noa_id and noa_family_code='APP'
309: AND
310: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families
311: where noa_family_code='APPT_TRANS');

Line 310: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families

306: Cursor fam_code(p_second_noa_id number) is
307: select noa_family_code from ghr_noa_families
308: where nature_of_action_id=p_second_noa_id and noa_family_code='APP'
309: AND
310: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families
311: where noa_family_code='APPT_TRANS');
312:
313: CURSOR cur_temp_step
314: IS