1352: KLE_ID,
1353: DNZ_KHR_ID,
1354: ASSET_NUMBER,
1355: DESCRIPTION
1356: FROM OKL_TXL_ASSETS_V
1357: WHERE nvl(OKL_TXL_ASSETS_V.TAS_ID,-9999) = p_tas_id;
1358: Type r_rec is record( ID NUMBER,
1359: KLE_ID NUMBER,
1360: DNZ_KHR_ID NUMBER,
1353: DNZ_KHR_ID,
1354: ASSET_NUMBER,
1355: DESCRIPTION
1356: FROM OKL_TXL_ASSETS_V
1357: WHERE nvl(OKL_TXL_ASSETS_V.TAS_ID,-9999) = p_tas_id;
1358: Type r_rec is record( ID NUMBER,
1359: KLE_ID NUMBER,
1360: DNZ_KHR_ID NUMBER,
1361: ASSET_NUMBER VARCHAR2(30),