APPS.POS_HZ_CONTACT_POINT_PKG dependencies on HZ_CONTACT_POINTS

Line 23: FROM hz_contact_points

19: IS
20: CURSOR l_cur IS
21: SELECT contact_point_id, object_version_number,
22: phone_number, phone_area_code, phone_extension
23: FROM hz_contact_points
24: WHERE owner_table_name = p_owner_table_name
25: AND owner_table_id = p_owner_table_id
26: AND contact_point_type = 'PHONE'
27: AND phone_line_type = 'GEN'

Line 176: FROM hz_contact_points

172: IS
173: CURSOR l_cur IS
174: SELECT contact_point_id, object_version_number, phone_number,
175: phone_area_code, phone_extension
176: FROM hz_contact_points
177: WHERE owner_table_name = p_owner_table_name
178: AND owner_table_id = p_owner_table_id
179: AND contact_point_type = 'PHONE'
180: AND phone_line_type = 'FAX'

Line 304: FROM hz_contact_points

300: )
301: IS
302: CURSOR l_cur IS
303: SELECT contact_point_id, object_version_number, email_address
304: FROM hz_contact_points
305: WHERE owner_table_name = p_owner_table_name
306: AND owner_table_id = p_owner_table_id
307: AND contact_point_type = 'EMAIL'
308: AND primary_flag = 'Y'

Line 409: FROM hz_contact_points

405: IS
406: CURSOR l_cur IS
407: SELECT contact_point_id, object_version_number,
408: phone_number, phone_area_code, phone_extension
409: FROM hz_contact_points
410: WHERE owner_table_name = p_owner_table_name
411: AND owner_table_id = p_owner_table_id
412: AND contact_point_type = 'PHONE'
413: AND phone_line_type = 'GEN'

Line 553: FROM hz_contact_points

549: )
550: IS
551: CURSOR l_cur IS
552: SELECT contact_point_id, object_version_number, url
553: FROM hz_contact_points
554: WHERE owner_table_name = p_owner_table_name
555: AND owner_table_id = p_owner_table_id
556: AND contact_point_type = 'WEB'
557: AND status = 'A';