APPS.IRC_PARTY_API dependencies on HZ_PARTIES

Line 2054: l_party_number hz_parties.party_number%type;

2050: --
2051: l_msg_count number;
2052: l_msg_data varchar2(2000);
2053: l_var varchar2(1);
2054: l_party_number hz_parties.party_number%type;
2055: l_profile_id number;
2056: l_effective_start_date date;
2057: l_effective_end_date date;
2058: l_comment_id number;

Line 4100: from fnd_user fu, hz_parties hzp

4096: where user_name=upper(p_user_name);
4097: --
4098: cursor get_email_address is
4099: select nvl(fu.email_address, hzp.email_address)
4100: from fnd_user fu, hz_parties hzp
4101: where user_name=upper(p_user_name)
4102: and fu.person_party_id=hzp.party_id(+);
4103: --
4104: cursor get_notif_prefs(p_party_id number) is

Line 4200: -- and if it is NULL try getting it from HZ_PARTIES

4196: if p_email is not null then
4197: l_email_address := p_email;
4198: else
4199: -- if input email is NULL, try getting it from FND_USER
4200: -- and if it is NULL try getting it from HZ_PARTIES
4201: -- and if that is NULL, use the UserName
4202: open get_email_address;
4203: fetch get_email_address into l_email_address;
4204: close get_email_address;