APPS.HZ_CONTACT_PREFERENCE_BO_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 248

    SELECT contact_preference_id
    FROM HZ_CONTACT_PREFERENCES
    WHERE contact_level_table_id = l_contact_point_id
    AND contact_type = l_contact_type
    AND preference_code = l_preference_code
    AND trunc(preference_start_date) = trunc(l_preference_start_date)
    AND trunc(nvl(preference_start_date,sysdate)) = trunc(nvl(l_preference_start_date,sysdate))
    AND rownum = 1;

Line: 324

        HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(
          p_contact_preference_rec    => l_contact_pref_rec,
          p_object_version_number     => l_ovn,
          x_return_status             => x_return_status,
          x_msg_count                 => x_msg_count,
          x_msg_data                  => x_msg_data
        );