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 312: select noa_family_code from ghr_noa_families

308: where pa_request_id=p_pa_request_id and first_noa_code='002';
309:
310:
311: Cursor fam_code(p_second_noa_id number) is
312: select noa_family_code from ghr_noa_families
313: where nature_of_action_id=p_second_noa_id and noa_family_code='APP'
314: AND
315: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families
316: where noa_family_code='APPT_TRANS');

Line 315: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families

311: Cursor fam_code(p_second_noa_id number) is
312: select noa_family_code from ghr_noa_families
313: where nature_of_action_id=p_second_noa_id and noa_family_code='APP'
314: AND
315: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families
316: where noa_family_code='APPT_TRANS');
317:
318: CURSOR cur_temp_step
319: IS