APPS.FA_CUA_WB_EXT_PKG SQL Statements

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

Line: 9

     NB. FAXASSET actually calls faxdadb.pls to do the deletes.
         fa_cua_wb_ext_pkg.facuas1 is called from fa_det_add_pkg.delete_asset,
         not the workbench form itself.
  */

  PROCEDURE facuas1 ( x_asset_id in number ) IS

    Cursor C1 is
      select asset_hierarchy_id
      from fa_asset_hierarchy
      where asset_id = x_asset_id;

Line: 22

      delete from FA_ASSET_HIERARCHY
      where asset_hierarchy_id = c1_rec.asset_hierarchy_id;