5: SUBTYPE cimv_tbl_type is OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
6: SUBTYPE talv_rec_type is OKL_TXL_ASSETS_PUB.tlpv_rec_type;
7: SUBTYPE tadv_rec_type is OKL_TXD_ASSETS_PUB.adpv_rec_type;
8:
9: Cursor bk_dfs_csr( ctId okx_ast_bks_v.depreciation_category%TYPE,
10: effDat okx_ast_bks_v.acquisition_date%TYPE,
11: bk okx_ast_bks_v.book_type_code%TYPE) IS
12: select life_in_months,
13: deprn_method,
6: SUBTYPE talv_rec_type is OKL_TXL_ASSETS_PUB.tlpv_rec_type;
7: SUBTYPE tadv_rec_type is OKL_TXD_ASSETS_PUB.adpv_rec_type;
8:
9: Cursor bk_dfs_csr( ctId okx_ast_bks_v.depreciation_category%TYPE,
10: effDat okx_ast_bks_v.acquisition_date%TYPE,
11: bk okx_ast_bks_v.book_type_code%TYPE) IS
12: select life_in_months,
13: deprn_method,
14: adjusted_rate
7: SUBTYPE tadv_rec_type is OKL_TXD_ASSETS_PUB.adpv_rec_type;
8:
9: Cursor bk_dfs_csr( ctId okx_ast_bks_v.depreciation_category%TYPE,
10: effDat okx_ast_bks_v.acquisition_date%TYPE,
11: bk okx_ast_bks_v.book_type_code%TYPE) IS
12: select life_in_months,
13: deprn_method,
14: adjusted_rate
15: from okx_ast_ct_bk_dfs_v