APPS.IRC_PARTY_API dependencies on HZ_PARTIES

Line 2080: l_party_number hz_parties.party_number%type;

2076: --
2077: l_msg_count number;
2078: l_msg_data varchar2(2000);
2079: l_var varchar2(1);
2080: l_party_number hz_parties.party_number%type;
2081: l_profile_id number;
2082: l_effective_start_date date;
2083: l_effective_end_date date;
2084: l_comment_id number;

Line 4328: from fnd_user fu, hz_parties hzp

4324: where user_name=upper(p_user_name);
4325: --
4326: cursor get_email_address is
4327: select nvl(fu.email_address, hzp.email_address)
4328: from fnd_user fu, hz_parties hzp
4329: where user_name=upper(p_user_name)
4330: and fu.person_party_id=hzp.party_id(+);
4331: --
4332: cursor get_notif_prefs(p_party_id number) is

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

4424: if p_email is not null then
4425: l_email_address := p_email;
4426: else
4427: -- if input email is NULL, try getting it from FND_USER
4428: -- and if it is NULL try getting it from HZ_PARTIES
4429: -- and if that is NULL, use the UserName
4430: open get_email_address;
4431: fetch get_email_address into l_email_address;
4432: close get_email_address;