APPS.POS_SUPPLIER_NOTIFY_PKG dependencies on HZ_CONTACT_POINTS

Line 91: l_email_address hz_contact_points.email_address%TYPE;

87: l_contact_sql VARCHAR2(4000);
88:
89: l_first_name hz_parties.person_first_name%TYPE;
90: l_last_name hz_parties.person_last_name%TYPE;
91: l_email_address hz_contact_points.email_address%TYPE;
92: l_user_name fnd_user.user_name%TYPE;
93: l_user_email_address fnd_user.email_address%TYPE;
94:
95: l_contact_users_tbl wf_directory.UserTable;

Line 124: ' hz_contact_points hcpe, ' ||

120: ' fu.email_address ' ||
121: 'FROM hz_parties hp, ' ||
122: ' hz_relationships hzr, ' ||
123: ' hz_party_usg_assignments hpua, ' ||
124: ' hz_contact_points hcpe, ' ||
125: ' fnd_user fu, ' ||
126: ' ap_suppliers aps ' ||
127: 'WHERE hp.party_id = hzr.subject_id ' ||
128: ' AND hzr.object_id = aps.party_id ' ||