APPS.OZF_CHECK_DUP_PROD_PVT SQL Statements

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

Line: 29

  SELECT sql_validation_1,
         sql_validation_2,
         sql_validation_3,
         sql_validation_4,
         sql_validation_5,
         sql_validation_6,
         sql_validation_7,
         sql_validation_8,
         condition_id_column
  FROM   ozf_denorm_queries
  WHERE  context = p_context
  AND    attribute = p_attribute
  AND    active_flag = 'Y'
  AND    last_update_date =
         (
         SELECT MAX(last_update_date)
         FROM   ozf_denorm_queries
         WHERE  context = p_context
         AND    attribute = p_attribute
         AND    active_flag = 'Y'
         );

Line: 69

      FND_DSQL.add_text('SELECT TO_NUMBER(');

Line: 135

  SELECT offer_discount_line_id
  FROM   ozf_offer_discount_lines
  WHERE  offer_id = p_offer_id
  AND    tier_type = 'PBH'
  AND    tier_level = 'HEADER';

Line: 142

  SELECT COUNT(*)
  FROM   ozf_offer_discount_lines
  WHERE  offer_id = p_offer_id
  AND    tier_type = 'PBH'
  AND    tier_level = 'HEADER';

Line: 149

  SELECT product_context,
         product_attribute,
         product_attr_value
  FROM   ozf_offer_discount_products
  WHERE  offer_id = p_offer_id
  AND    offer_discount_line_id = p_pbh_line_id
  AND    excluder_flag = p_excluder_flag;

Line: 159

  SELECT COUNT(*)
  FROM   ozf_offer_discount_products
  WHERE  offer_id = p_offer_id
  AND    offer_discount_line_id = p_pbh_line_id
  AND    excluder_flag = p_excluder_flag;

Line: 203

      FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');

Line: 204

      FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');

Line: 205

      FND_DSQL.add_text('last_updated_by,last_update_login,');

Line: 207

      FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

Line: 313

  SELECT 'Y' FROM DUAL
  WHERE EXISTS(
               SELECT 1
               FROM   ozf_vo_products_temp
               HAVING COUNT(product_id) > 1
               GROUP BY product_id
              );

Line: 321

  DELETE FROM ozf_vo_products_temp;

Line: 341

  FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');

Line: 342

  FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');

Line: 343

  FND_DSQL.add_text('last_updated_by,last_update_login,');

Line: 345

  FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');