update sq_product_description sqpd
        set (short_description
            ,long_description
            ,update_date
            ,update_source)=
    ( select ifl.short_description
            ,ifl.long_description
            ,sysdate
            ,'nancy'
     from if_nan_prod_l ifl
        ,if_parameters ip
   where sqpd.product_code = ifl.product_code
    and sqpd.locale_language =trim(ifl.LANGUAGE_CODE)
    and sqpd.locale_country  =ip.country_code
    and ip.interface_id='NAN')
            where exists (
            select  1
                from if_nan_prod_l ifl
                    ,if_parameters ip
            where sqpd.product_code = ifl.product_code
                    and sqpd.locale_language = trim(ifl.LANGUAGE_CODE)
                    and sqpd.locale_country =ip.country_code
                    and ip.interface_id='NAN'
                    and (sqpd.short_description <> ifl.short_description
                    or sqpd.long_description <> ifl.long_description
                        )
                    );