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:
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:
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: