DBA Data[Home] [Help]

APPS.AMS_PHONE_UTILS dependencies on HZ_CONTACT_POINTS

Line 66: from hz_contact_points

62: IS
63: -- Get records
64: cursor phones (c_party_id number) is
65: select phone_number
66: from hz_contact_points
67: where owner_table_id = c_party_id
68: and owner_table_name = 'HZ_PARTIES'
69: order by creation_date;
70:

Line 122: from hz_contact_points

118: IS
119: -- Get records
120: cursor phones (c_party_id number) is
121: select raw_phone_number
122: from hz_contact_points
123: where owner_table_id = c_party_id
124: and owner_table_name = 'HZ_PARTIES'
125: order by creation_date;
126:

Line 178: from hz_contact_points

174: IS
175: -- Get records
176: cursor phones (c_party_id number) is
177: select creation_date
178: from hz_contact_points
179: where owner_table_id = c_party_id
180: and owner_table_name = 'HZ_PARTIES'
181: order by creation_date;
182: