APPS.IEX_TERR_PUB dependencies on HZ_PARTIES

Line 884: l_party_name hz_parties.party_name%type;

880: l_where varchar2(240);
881: Type refCur is Ref Cursor;
882: l_curs refCur;
883:
884: l_party_name hz_parties.party_name%type;
885: l_account_name hz_cust_accounts.account_name%type;
886: l_address1 varchar2(240);
887: l_city varchar2(240);
888: l_state varchar2(240);

Line 922: ' hz_parties party, ' ||

918: ' phone.phone_number phone_number, ' ||
919: ' phone.phone_extension phone_extension ' ||
920: ' FROM ' ||
921: ' hz_cust_accounts acc, ' ||
922: ' hz_parties party, ' ||
923: ' fnd_territories_tl fnd_terr, ' ||
924: ' hz_contact_points phone ' ||
925: ' WHERE ' ||
926: ' acc.party_id = party.party_id ' ||

Line 928: ' AND phone.owner_table_name(+) = ''HZ_PARTIES'' ' ||

924: ' hz_contact_points phone ' ||
925: ' WHERE ' ||
926: ' acc.party_id = party.party_id ' ||
927: ' AND phone.owner_table_id(+) = party.party_id ' ||
928: ' AND phone.owner_table_name(+) = ''HZ_PARTIES'' ' ||
929: ' AND phone.contact_point_type(+) = ''PHONE'' ' ||
930: ' AND phone.primary_by_purpose(+) = ''Y'' ' ||
931: ' AND phone.contact_point_purpose(+) = ''COLLECTIONS'' ' ||
932: ' AND phone.phone_line_type(+) NOT IN(''PAGER'', ''FAX'') ' ||