APPS.CSI_ASSET_VLD_PVT SQL Statements

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

Line: 82

	SELECT 'x'
	FROM csi_item_instances
	WHERE instance_id = p_instance_id
     and  ((active_end_date is null) OR (active_end_date >= sysdate));

Line: 88

	SELECT 'x'
	FROM csi_item_instances
	WHERE instance_id = p_instance_id;

Line: 135

 SELECT CSI_I_ASSETS_S.nextval
  INTO  l_inst_asset_id
  FROM sys.dual;

Line: 158

   	SELECT 'x'
     INTO l_dummy
     FROM csi_i_assets
	WHERE instance_asset_id = p_instance_asset_id ;

Line: 190

   	SELECT 'x'
     INTO l_dummy
     FROM csi_i_assets
	WHERE instance_asset_id = p_instance_asset_id ;

Line: 208

/* Procedure name: Is_Update_Status_Exists                   */
/* Description : Check if the update status  is              */
/*              defined in CSI_LOOKUPS                       */
/*-----------------------------------------------------------*/

FUNCTION Is_Update_Status_Exists
(
    p_update_status         IN      VARCHAR2,
	p_stack_err_msg         IN      BOOLEAN
) RETURN BOOLEAN IS

	l_dummy                 VARCHAR2(1);

Line: 221

        l_asset_lookup_type     VARCHAR2(30) := 'CSI_ASSET_UPDATE_STATUS_CODE';

Line: 224

	SELECT 'x'
	FROM CSI_LOOKUPS
	WHERE  UPPER(lookup_code) = UPPER(p_update_status)
        AND  lookup_type      = l_asset_lookup_type;

Line: 234

		   FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');

Line: 235

		   FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_update_status);

Line: 242

END Is_Update_Status_Exists;

Line: 281

  SELECT CSI_I_ASSETS_H_S.nextval
  INTO  l_inst_asset_hist_id
  FROM sys.dual;

Line: 302

 SELECT 'x'
  FROM fa_books
 WHERE asset_id       = p_asset_id
  and  book_type_code = p_book_type_code
  and  rownum = 1 ;

Line: 337

   	SELECT 'x'
     INTO l_dummy
     FROM csi_a_locations
	WHERE fa_location_id   = p_location_id
      and  ((active_end_date is null) OR (active_end_date >= sysdate))
      and  ROWNUM = 1;

Line: 375

	SELECT active_start_date,
           active_end_date
	FROM   csi_item_instances
	WHERE  instance_id = p_instance_id
      AND  ((active_end_date IS NULL) OR (active_end_date >= SYSDATE));

Line: 452

       SELECT active_start_date,
              active_end_date
       FROM   csi_item_instances
       WHERE  instance_id = p_instance_id;

Line: 476

             SELECT MAX(t.transaction_date)
             INTO   l_transaction_date
             FROM   csi_i_assets_h s,
                    csi_transactions t
             WHERE  s.instance_asset_id=p_inst_asset_id
             AND    s.transaction_id=t.transaction_id
	         AND    t.transaction_id <> nvl(p_txn_id, -999999);