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_MTI_INT dependencies on GHR_MT_ADDRESSES_V

Line 382: l_address ghr_mt_addresses_v%rowtype;

378:
379: l_pei ghr_mt_people_ei_v%rowtype;
380: l_sit ghr_mt_analysis_criteria_v%rowtype;
381: l_hr_user_type varchar2(20);
382: l_address ghr_mt_addresses_v%rowtype;
383:
384: --
385: -- select all people extra info rows by transfer name and
386: -- person_id, The person_id must uniquely identify all information

Line 403: from ghr_mt_addresses_v

399: and mt_person_id = p_tran.mt_person_id;
400:
401: cursor cur_address is
402: select *
403: from ghr_mt_addresses_v
404: where mt_name = p_transfer_name
405: and mt_person_id = p_tran.mt_person_id
406: and mt_contact_name is null;
407:

Line 411: from ghr_mt_addresses_v

407:
408: /*
409: cursor cur_contact_address is
410: select *
411: from ghr_mt_addresses_v
412: where mt_name = p_transfer_name
413: and mt_person_id = p_tran.mt_person_id
414: and mt_contact_name is not null;
415: */