APPS.AST_UWQ_WRAPPER_PKG dependencies on HZ_CONTACT_POINTS

Line 221: FROM hz_contact_points

217: AND location_id = x_location_id;
218:
219: CURSOR c_phone_id(x_owner_table_id number) IS
220: SELECT contact_point_id
221: FROM hz_contact_points
222: WHERE owner_table_id = x_owner_table_id
223: and owner_table_name = 'HZ_PARTIES'
224: and contact_point_type = 'PHONE'
225: and status = 'A'

Line 1100: FROM hz_contact_points

1096: AND r.directional_flag = 'F';
1097:
1098: CURSOR c_phone_id(x_owner_table_id number) IS
1099: SELECT contact_point_id
1100: FROM hz_contact_points
1101: WHERE owner_table_id = x_owner_table_id
1102: and owner_table_name = 'HZ_PARTIES'
1103: and contact_point_type = 'PHONE'
1104: and primary_flag = 'Y';