[Home] [Help]
2736: AND cls.lty_code = 'ITEM';
2737: -- to find the asset_num
2738: CURSOR find_asset_num_csr(p_fin_line_id NUMBER) IS
2739: SELECT name
2740: FROM OKC_K_LINES_V
2741: WHERE id = p_fin_line_id;
2742: --get asset add ons
2743: CURSOR c_get_asset_addons(p_ast_id okl_assets_b.ID%TYPE) IS
2744: SELECT oab.ID,