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.IRC_PARTY_PERSON_UTL dependencies on HZ_PARTIES

Line 28: from hz_parties

24: l_employee_number varchar2(255);
25:
26: cursor get_party_id1 is
27: select party_id,party_id person_id
28: from hz_parties
29: where orig_system_reference='PER:IRC'
30: union
31: select party_id,person_id
32: from irc_notification_preferences;

Line 36: from hz_parties

32: from irc_notification_preferences;
33:
34: cursor get_party_id2 is
35: select party_id,party_id person_id
36: from hz_parties
37: where orig_system_reference='PER:IRC'
38: union
39: select party_id,person_id
40: from irc_notification_preferences

Line 106: , hz_parties hzp

102: ,hzpp.person_first_name_phonetic
103: ,hzpp.person_last_name_phonetic
104: ,hzp.creation_date
105: from hz_person_profiles hzpp
106: , hz_parties hzp
107: where hzpp.party_id=p_party_id
108: and hzp.party_id=hzpp.party_id
109: and sysdate between hzpp.effective_start_date and nvl(hzpp.effective_end_date,sysdate);
110: