4158: AND transaction_header_id_out is null
4159: AND sysdate between start_date_active and nvl(end_date_active,sysdate+1)
4160: AND rownum < 2;
4161:
4162: CURSOR c_asset_details_info(p_object1_id1 OKX_AST_BKS_V.ID1%TYPE) IS
4163: SELECT *
4164: FROM OKX_AST_BKS_V
4165: WHERE id1 = p_object1_id1
4166: AND book_class = 'TAX';
4160: AND rownum < 2;
4161:
4162: CURSOR c_asset_details_info(p_object1_id1 OKX_AST_BKS_V.ID1%TYPE) IS
4163: SELECT *
4164: FROM OKX_AST_BKS_V
4165: WHERE id1 = p_object1_id1
4166: AND book_class = 'TAX';
4167:
4168: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,