APPS.CS_UPDATE_CP_SHIPPED_FLAG SQL Statements

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

Line: 17

      select min(customer_product_id)
      from   cs_customer_products_all;

Line: 21

      select max(customer_product_id)
      from   cs_customer_products_all;

Line: 25

      select ccp.customer_product_id,
             ccp.shipped_flag,
             nvl(ccp.upgraded_status_flag,'N'),
             ccp.rowid
      from  cs_customer_products_all ccp
      where customer_product_id >= p_start and customer_product_id <= p_end
	 and   ccp.shipped_flag <> 'Y'
	 and   ccp.upgraded_status_flag = 'Y';

Line: 74

      	     UPDATE cs_customer_products_all
	     SET    shipped_flag = shipped_flag_mig(j)
             WHERE  rowid = Rowid_mig(j);