eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_MIGRATE_TAX_PROFILES SQL Statements

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

Line: 33


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values
WHERE    profile_option_id = (select profile_option_id
                              from   fnd_profile_options
                              where  profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS')
AND     NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values
                    WHERE  profile_option_id = (SELECT profile_option_id
                                                FROM   fnd_profile_options
                                                WHERE  profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS')
                   );

Line: 74


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_ALLOW_TAX_UPDATE'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values
WHERE    profile_option_id = (select profile_option_id
                              from   fnd_profile_options
                              where  profile_option_name = 'AR_ALLOW_TAX_UPDATE')
AND     APPLICATION_ID     = 222
AND     NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values
                    WHERE  profile_option_id = (SELECT profile_option_id
                                                FROM   fnd_profile_options
                                                WHERE  profile_option_name = 'ZX_ALLOW_TAX_UPDATE')
                   );

Line: 116


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values
WHERE    profile_option_id = (select profile_option_id
                              from   fnd_profile_options
                              where  profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES')
AND     NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values
                    WHERE  profile_option_id = (SELECT profile_option_id
                                                FROM   fnd_profile_options
                                                WHERE  profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
                   );

Line: 157


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values
WHERE    profile_option_id = (select profile_option_id
                              from   fnd_profile_options
                              where  profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT')
AND     NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values
                    WHERE  profile_option_id = (SELECT profile_option_id
                                                FROM   fnd_profile_options
                                                WHERE  profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT')
                   );

Line: 199


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values
WHERE    profile_option_id = (select profile_option_id
                              from   fnd_profile_options
                              where  profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE')
AND     NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values
                    WHERE  profile_option_id = (SELECT profile_option_id
                                                FROM   fnd_profile_options
                                                WHERE  profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE')
                   );

Line: 241


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values
WHERE    profile_option_id = (select profile_option_id
                              from   fnd_profile_options
                              where  profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
AND     NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values
                    WHERE  profile_option_id = (SELECT profile_option_id
                                                FROM   fnd_profile_options
                                                WHERE  profile_option_name = 'ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
                   );

Line: 282


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values
WHERE    profile_option_id = (select profile_option_id
                              from   fnd_profile_options
                              where  profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE')
--Bug 13371914
AND     application_id = 222
AND     NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values
                    WHERE  profile_option_id = (SELECT profile_option_id
                                                FROM   fnd_profile_options
                                                WHERE  profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE')
                   );

Line: 327


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_TAXVDR_USENEXPRO'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values valar
       , fnd_profile_options fpoar
WHERE    valar.profile_option_id = fpoar.profile_option_id
AND      fpoar.profile_option_name = 'AR_TAXVDR_USENEXPRO'
AND      NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values valzx
                         , fnd_profile_options fpozx
                    WHERE  valzx.profile_option_id = fpozx.profile_option_id
                      AND  fpozx.profile_option_name = 'ZX_TAXVDR_USENEXPRO');

Line: 367


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_TAXVDR_TAXSELPARAM'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values valar
       , fnd_profile_options fpoar
WHERE    valar.profile_option_id = fpoar.profile_option_id
AND      fpoar.profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
AND      NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values valzx
                         , fnd_profile_options fpozx
                    WHERE  valzx.profile_option_id = fpozx.profile_option_id
                      AND  fpozx.profile_option_name = 'ZX_TAXVDR_TAXSELPARAM');

Line: 408


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_TAXVDR_TAXTYPE'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values valar
       , fnd_profile_options fpoar
WHERE    valar.profile_option_id = fpoar.profile_option_id
AND      fpoar.profile_option_name = 'AR_TAXVDR_TAXTYPE'
AND      NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values valzx
                         , fnd_profile_options fpozx
                    WHERE  valzx.profile_option_id = fpozx.profile_option_id
                      AND  fpozx.profile_option_name = 'ZX_TAXVDR_TAXTYPE');

Line: 449


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_TAXVDR_SERVICEIND'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values valar
       , fnd_profile_options fpoar
WHERE    valar.profile_option_id = fpoar.profile_option_id
AND      fpoar.profile_option_name = 'AR_TAXVDR_SERVICEIND'
AND      NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values valzx
                         , fnd_profile_options fpozx
                    WHERE  valzx.profile_option_id = fpozx.profile_option_id
                      AND  fpozx.profile_option_name = 'ZX_TAXVDR_SERVICEIND');

Line: 489


INSERT INTO FND_PROFILE_OPTION_VALUES
(
 APPLICATION_ID                  ,
 PROFILE_OPTION_ID               ,
 LEVEL_ID                        ,
 LEVEL_VALUE                     ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN               ,
 PROFILE_OPTION_VALUE            ,
 LEVEL_VALUE_APPLICATION_ID
)
SELECT
 235,                               -- APPLICATION_ID
 (select profile_option_id
  from   fnd_profile_options
  where  profile_option_name = 'ZX_TAXVDR_CASESENSITIVE'), -- PROFILE_OPTION_ID
 LEVEL_ID,
 LEVEL_VALUE,
 sysdate,                        --LAST_UPDATE_DATE
 fnd_global.user_id,             --LAST_UPDATED_BY
 sysdate,                        --CREATION_DATE
 fnd_global.user_id,             --CREATED_BY
 fnd_global.conc_login_id,       --LAST_UPDATE_LOGIN
 PROFILE_OPTION_VALUE,
 LEVEL_VALUE_APPLICATION_ID
FROM     fnd_profile_option_values valar
       , fnd_profile_options fpoar
WHERE    valar.profile_option_id = fpoar.profile_option_id
AND      fpoar.profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
AND      NOT EXISTS (SELECT 1
                    FROM   fnd_profile_option_values valzx
                         , fnd_profile_options fpozx
                    WHERE  valzx.profile_option_id = fpozx.profile_option_id
                      AND  fpozx.profile_option_name = 'ZX_TAXVDR_CASESENSITIVE');

Line: 567


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS'
AND    end_date_active IS NULL;

Line: 577


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name = 'AR_ALLOW_TAX_UPDATE'
AND    end_date_active IS NULL;

Line: 587


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES'
AND    end_date_active IS NULL;

Line: 597


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT'
AND    end_date_active IS NULL;

Line: 608


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE'
AND    end_date_active IS NULL;

Line: 618


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE'
AND    end_date_active IS NULL;

Line: 628


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE'
AND    end_date_active IS NULL;

Line: 640


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name = 'AR_TAXVDR_USENEXPRO'
AND    end_date_active IS NULL;

Line: 650


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name =  'AR_TAXVDR_TAXSELPARAM'
AND    end_date_active IS NULL;

Line: 660


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name =  'AR_TAXVDR_TAXTYPE'
AND    end_date_active IS NULL;

Line: 670


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name =  'AR_TAXVDR_SERVICEIND'
AND    end_date_active IS NULL;

Line: 680


UPDATE fnd_profile_options
SET    END_DATE_ACTIVE = sysdate,
       LAST_UPDATE_DATE = sysdate,
       LAST_UPDATED_BY = fnd_global.user_id,
       LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE  profile_option_name =  'AR_TAXVDR_CASESENSITIVE'
AND    end_date_active IS NULL;